Parsing pipped characters

[James Gill]

I don't have very much experience in parsing text. I have a field that contains a set of set of values that are separated by the "|" character. I would like to be able to pull the data held within the pipes for a specific position but I don't know how to do that.

Say I have the following value in a text field;

Train|Bus|Car|Plane

how would I go about making a calc that pulls Car from that data set?

Edited September 30, 2010 by Guest
ID Field Type

[comment]

Try =

GetValue ( Substitute ( text ; "|" ; ¶ ) ; 3 )

[James Gill]

Thanks! That works perfectly.