Split String

[boyracer38]

I have a string which i want to split and feed into local variable. The string needs to be split into several parts.

I basically need something which is opposite to the concatenate function....

I have tried 'slit string, but this only splits a string in 2...

Thanks

Jason

[malef]

Use "Scan From String" function.

[Mark Balla]

Can you give an example of what you are tring to do.

[Bryan]

By what delimitation are you trying to split the string? Are you trying to break it up into pieces by finding spaces, commas, etc?

If you're trying to do the above, you can use the "Spreadsheet to Array" function which will provide an array of each "piece" of your string that's separated by a character (i.e. comma, space, tab, etc).

Or use the "Scan from String" function.

[boyracer38]

Thanks for your comments. I used scan from string in the end. Its worked a treat.

Regards

Jason