Splitting up a String

[borisbe]

I have a string field. Examples:

121 100 106 111 115 301 302 305 306 307 308 311 312
106
103 106 110 111 131 115 301 302 305 306 308 309 310 311

How can I split up this field so each of the set of numbers is a separate field?

Thanks

 

[lbass]

If the string always contains the same number of components, you could use:

split({table.string}," ")[1]//change the number for each component

If the number of components can change, then use a formula like the following for each possible member of the array:

if ubound(split({table.string}," ")) >= 3 then
split({table.string}," ")[3]
//for the third member

-LB

 

[borisbe]

Thanks lbass. The second formula worked wonderful. You have made my day.