Extracting Data from A String 1

[jdgreen]

I am using CRXI and have an issue retrieving data from a table. The data in the table is stored in the following format:
2.3454;0;0;0;0
24.35;0;0;0;0
2.32;0;0;0;0
I need to only retrieve the first number from the array.
Thanks


John Green

 

[lbass]

You could use:

left({table.string},instr({table.string},";")-1)

Or you could use:

split({table.string},";")[1]

-LB