AnsweredAssumed Answered

MiddleWords separator character?

Question asked by disabled_JustinClose on Jul 5, 2012
Latest reply on Jul 27, 2012 by disabled_JustinClose


MiddleWords separator character?

Your post

Is there a way to suppress a certain word separator?  I am trying to parse the results of an ExecuteSQL query into separate fields.  Using MiddleWords() would work well in a loop, except that some of my data may contain spaces:

middlewords("14|Delivery|Production Coordinator|23"; 3 ; 1 )

Returns "Production" only.  (I was going to use counters in place of the 3 and 1 for the loop.)  I have multiple lines returning, so don't want to use a CR or something as the record separator.  I used pipe just because I like em, and they are usually easy to handle.  Hand't realized, at the time, that it would work as a word separator for ###Words() functions.

Any suggestions about how to handle this?  Or better ways to parse the resulting SQL string?