Text character occurance

[moxie]

I've got a field with a character that repeats itself throughout "%".

I want to pull data from between these occurances into separate fields.

So "field l" would be all data up to the first occurance of "%".

"Field 2" would be data from the first occurance to the second "%", and so on...

[mr_vodka]

Try

Trim ( Substitute ( MiddleValues ( Substitute ( Parent::parsefield; "%"; "¶"); x; 1); "¶"; "" ) )

Where x is the location for the parsed value that you want.

[comment]

This assumes there are no carriage returns in the parsed text.

[moxie]

Thanks worked well.

---

scott