Simple RegExpr problem

Can someone with reg expr fu please please help me?

I’m not getting anywhere-
Just need to split the vales in this txt file in to slices. seems like it should be easy but it has me stumped- I really don’t know reg expr very well- generally try to use csv or xml for bringing data in to vvvv, but it’s not possible in this case.

Example below, not sure if the formatting will be clear on the forum so *.txt file is also attached.

Much lovin in advance!

0 -20.905 6.214 145.492 13.873 -32.469 -14.313 59.645
1 -20.890 6.224 145.475 13.828 -32.182 -14.111 59.645
2 -20.880 6.230 145.454 13.782 -31.892 -13.888 59.645
3 -20.850 6.217 145.438 13.722 -31.585 -13.651 59.645
4 -20.813 6.221 145.417 13.685 -31.304 -13.572 59.645
5 -20.773 6.224 145.395 13.700 -31.033 -13.588 59.645
6 -20.729 6.249 145.368 13.712 -30.789 -13.592 59.645
7 -20.670 6.246 145.335 13.748 -30.570 -13.543 59.645
8 -20.644 6.252 145.296 13.780 -30.418 -13.499 59.645
9 -20.622 6.263 145.253 13.769 -30.265 -13.470 59.645
10 -20.583 6.274 145.206 13.726 -30.106 -13.405 59.645
11 -20.552 6.303 145.158 13.695 -29.946 -13.370 59.645

test.txt (32.3 kB)

The post seems to have cleaned it to single spaces, in the file the gaps are made up of different amounts of spaces between different values.

i would say Separate (String) does the trick…?

that’s what i was trying and failing with before moving on to regexpr. Maybe I’m missing a setting- will separate work if the number of spaces are different? As in: 3 spaces, 5 space, n spaces etc?

Patch attached…

DataTest.v4p (5.0 kB)

<!DOCTYPE PATCH  SYSTEM "C:\apps\code\vvvv_45beta27\lib\45beta27.dtd" >
   <PATCH>
   <NODE nodename="IOBox (String)" componentmode="InABox" id="0" systemname="IOBox (String)">
   <BOUNDS type="Node" left="225" top="135" width="4335" height="2580">
   </BOUNDS>
   <BOUNDS type="Box" left="225" top="135" width="4335" height="2580">
   </BOUNDS>
   <PIN pinname="Input String" visible="0" slicecount="1" values="|0 -20.905 6.214 145.492 13.873 -32.469 -14.313 59.645&cr;&lf;1 -20.890 6.224 145.475 13.828 -32.182 -14.111 59.645&cr;&lf;2 -20.880 6.230 145.454 13.782 -31.892 -13.888 59.645&cr;&lf;3 -20.850 6.217 145.438 13.722 -31.585 -13.651 59.645&cr;&lf;4 -20.813 6.221 145.417 13.685 -31.304 -13.572 59.645&cr;&lf;5 -20.773 6.224 145.395 13.700 -31.033 -13.588 59.645&cr;&lf;6 -20.729 6.249 145.368 13.712 -30.789 -13.592 59.645&cr;&lf;7 -20.670 6.246 145.335 13.748 -30.570 -13.543 59.645&cr;&lf;8 -20.644 6.252 145.296 13.780 -30.418 -13.499 59.645&cr;&lf;9 -20.622 6.263 145.253 13.769 -30.265 -13.470 59.645&cr;&lf;10 -20.583 6.274 145.206 13.726 -30.106 -13.405 59.645&cr;&lf;11 -20.552 6.303 145.158 13.695 -29.946 -13.370 59.645|" encoded="0">
   </PIN>
   <PIN pinname="Output String" visible="1">
   </PIN>
   <PIN pinname="Show Grid" slicecount="1" values="0">
   </PIN>
   <PIN pinname="String Type" slicecount="1" values="MultiLine">
   </PIN>
   </NODE>
   <NODE systemname="Separate (String)" nodename="Separate (String)" componentmode="Hidden" id="1">
   <BOUNDS type="Node" left="225" top="3060" width="100" height="100">
   </BOUNDS>
   <PIN pinname="Intersperse String" slicecount="1" values="||" encoded="0">
   </PIN>
   <PIN pinname="Intersperse" slicecount="1" values="NewLineAutoDetection">
   </PIN>
   <PIN pinname="Input" visible="1">
   </PIN>
   <PIN pinname="Output" visible="1">
   </PIN>
   </NODE>
   <LINK srcnodeid="0" srcpinname="Output String" dstnodeid="1" dstpinname="Input">
   </LINK>
   <NODE systemname="Separate (String)" nodename="Separate (String)" componentmode="Hidden" id="2">
   <BOUNDS type="Node" left="225" top="3690" width="100" height="100">
   </BOUNDS>
   <PIN pinname="Input" visible="1">
   </PIN>
   <PIN pinname="Intersperse" slicecount="1" values="Space">
   </PIN>
   </NODE>
   <LINK srcnodeid="1" srcpinname="Output" dstnodeid="2" dstpinname="Input">
   </LINK>
   <NODE nodename="IOBox (String)" componentmode="InABox" id="3" systemname="IOBox (String)">
   <BOUNDS type="Node" left="225" top="4395" width="0" height="0">
   </BOUNDS>
   <BOUNDS type="Box" left="225" top="4395" width="7350" height="3420">
   </BOUNDS>
   <PIN pinname="Default" slicecount="1" values="||" encoded="0">
   </PIN>
   <PIN pinname="File Mask" slicecount="1" values="||" encoded="0">
   </PIN>
   <PIN pinname="Maximum Characters" slicecount="1" values="-1">
   </PIN>
   <PIN pinname="String Type" slicecount="1" values="MultiLine">
   </PIN>
   <PIN pinname="Rows" slicecount="1" values="12">
   </PIN>
   <PIN pinname="Columns" slicecount="1" values="8">
   </PIN>
   </NODE>
   <LINK srcnodeid="2" srcpinname="Output" dstnodeid="3" dstpinname="Input String">
   </LINK>
   </PATCH>

for me the Separate (String) does the work

DataTest.v4p (6.2 kB)

Thanks phlegma, the strip node is what I was missing.
Beer in the mail :)