Our full technical support staff does not monitor this forum. If you need assistance from a member of our staff, please submit your question from the Ask a Question page.


Log in or register to post/reply in the forum.

Splitting up a string


Lights Apr 21, 2020 04:19 PM

Looking to parse the data out of this string the data is after the ; delimiters I need the data after K,J,A,B,C,D,E,F,AF,

$Apt,K;21/04/2020,J;08:20:16.4,O;0,A;0.0,B;0.0,C;0.0,D;0.0,E;307.8,F;20.9,AG;3.2,AE;3.0,AF;0.0,G;999.999999,H;999.999999,AD;3.7,AH;4012960%


JDavis Apr 21, 2020 04:52 PM

The easiest way to get it right is to use SplitStr() multiple times. First use SplitStr() with comma as the delimiter to break it up into chunks. Then on each chunk, use SplitStr with semicolon as the delimited. The second piece of each chunk is your number.

It should also be possible to do with once through SplitStr() using a filter characters option. With that you would provide SplitStr() with a list that includes the comma, semicolon, and all of those letters.That method might take you a couple tries to get adjusted right.

Log in or register to post/reply in the forum.