Post Author: simon82
CA Forum: Formula
I am currently having a problem splitting a field into other "fields"
i have been using the split function so
split()  - This is ok up to this point Split ()  - 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?