How to fast split a string in sub-strings

[OnlyOne]

Hello,

i have a string with 8 fields divided with a separator. For example:

C|text|20140910-132435|1|A|0,000|0,000|3

Currently i use "MatchPattern" to split this string into the fields.

For 200.000 loops it akes ~1sec

Can this be done faster?

Thanks

[dan_u]

Maybe simpler would be to use spreadsheet string to array with '|' as delimiter. Array type 1D-array of strings.

I wouldn't expect this method to be faster, though.

[OnlyOne]

Thanks. I tested it but ist 0.4sec slower against MatchPattern.

[Richard_Ha]

I've modified your timing setp up slightly.

There's no need to subtract and update the indicator 20k times.

[crossrulz]

If your format is never going to change, I like the Scan From String.

[OnlyOne]

@Richard_Ha

I can only open Vi´s Labview 2013 😞

@crossrulz

How to set the format-string for ScanFromString? %s|%s|%s|%u|%s|%f|%f|%u is not working, how do i set the separator here?

Thanks

[crossrulz]

Use "[^|]" for the strings.  That will give you a string up to (but not including) the |.

[Richard_Ha]

2013 Version

[Matthew_Kelton]

Simply moving the string to number conversions outside the loop reduced time by a factor of 3 on my system (280ms for your code to 90ms).  I had to replace the scan from string to fract/exp string to number, but the string functions will take arrays and output arrays.

EDIT:  I also moved the timing calculation to a frame after the for loop to remove the needless update of the indicator for my numbers above.

[Richard_Ha]

Are you also making use of parrallel for loops?