Skip to Content
0
Former Member
Jun 29, 2007 at 11:24 AM

Array Problem

24 Views

Post Author: simon82

CA Forum: Formula

Hello,

I am currently having a problem splitting a field into other "fields"

i have been using the split function so

split() [1] - This is ok up to this point Split () [2] - This is ok but falls over if there is not 2 elements.

Some names have 1 element, some may have several.

how can i write a formula to extract all the elements using " " as the delimeter?

Thanks