Parsing text

[Greg G]

I have a text field where there are up to 8 values seperated by plus signs (+). Is there a way to seperate out this data and place it into other fields?

Example data: R435+L234H+R135+G119+R336H

Thanks,

Greg

[comment]

If there are no spaces or other word separators (other than the plus sign), you could use the MiddleWords() function to extract each individual value.

Otherwise you could substitute the plus signs for carriage returns, then use GetValue().

[Greg G]

Middlewords works great. In fact, it's even smart enough to ignore most common seperators between the words such as "+ , -" etc. with or without spaces as long as there is some non-letter/number seperator.

Thanks for the help.

Greg