Tersus: Text Split action - any way to output 'null' where no text between separators?

Text Split action - any way to output 'null' where no text between separators?Date: Oct 2, 2008I'm using Split to separate text elements contained within a text string, using two different separator characters, and insert a database record with the output text in separate fields. Split is working perfectly but it would save me a lot of hassle if there were a way to output nulls where there is no text between two separators (a common occurrence in what I'm trying to model) - the empty text elements are important as I need to record the empty fields. Can you help, please?David BeattieSee Also:

Re: Text Split action - any way to output 'null' where no text between separators?

To use the full functionality of this web site, JavaScript needs to be turned on.

For best results, use the Firefox browser..

Loading ...