separate the column in txt without space

[varsha88]

hi,

i have a txt file which im able to read in Labview. i need to read the column and separate it accordingly. 

0000014123B --> 0000 014 123 B (from single column convert to 4 columns)

Meaning to say, the input need to be separate into 4 different column as above. attached is the txt file.

[crossrulz]

Is it always 4 characters, then 3, 3, and 1?  If so, just use Substring.

[rpursley8]

Take a look at this

[GerdW]

Hi Randall,

just slightly Rube-Goldberg… 😄

No need to build lines and remove the EOL, to finally put all lines with their EOL chars in a spreadsheet string. Just do it with one function… (Your version might be more memory efficient with bigger string arrays.)

[Darin.K]

Simple to use a loop to create dynamic search and replace strings based on an array of widths as well.

[GerdW]

Hi Darin,

I really should learn RegEx someday… 😄

[varsha88]

hi, thanks for the quick response. can i have the vi since i am new to labview and not familiar with the palettes. thanks

[GerdW]

Hi,

it's a SNIPPET!

[varsha88]

hi,

i have created the vi as per in the image but i still cannot read the value.refer to the attachment. Can anyone advise me on that? thanks

[GerdW · Accepted solution]

Hi varsha,

- you forgot to enable the "Regular Expression" mode in the right-click menu of the parse function (did you notice the small star in the symbol?)

- you wired the TRUE constant to the  wrong input

- the second string constant should be set to \-code display mode (well, I guess there's a LabVIEW idea to show the display mode of string constants by default…)