Seperate string in parts

[Sebastian Flachs]

Hello
I have the following problem:
I have a string with various values. It looks like that:" 205,0;1; 20,0;0; 65,0;22,0; 50;1;1;2500;Comment"
Some values have a defnite width " 205,0" for example.
Now I hav to seperate all these values and write each to a local variable, so that I can use the value for some calculations.
How can I do this easily?

Thanks for your help

[Mads]

Just use the scan from string function (see attached solution example) with the correct format string...

[mikeporter]

It looks like you have semicolons between values (;) so another alternative is to use the "spreadsheet string to array" function with a semicolon as the delimiter. This will result in a 1D array of your values that you can then index apart.

In some ways this is a more general solution because scan from string can start behaving strangely when parsing stings containing values that will be interpreted as text (like the comment at the end of your example).

Mike...

[Sebastian Flachs]

Yes you may be right. But my programm only creates the strings in that way. so you have to change the sourcecode for other values.

[mikeporter]

I think you misunderstood what I meant. You can leave your existing code the way it is. All I was talking about is how you could parse the string the existing code generates.

Mike...

[Sebastian Flachs]

Yes sorry, it was my mistake. Thanks for your help.