Displaying a string to the right of the first space 1

[darwin101]

Hi All

Is it possiable to select the text after the first space in a text field?
For example I would only want to print the Name after the first space "Bob"
aspex1- Bob
wr- Bob
A1 Bob
2 Bob

Thanks

 

[synapsevampire]

Try:

mid({Bob.Ship Via},instr({Bob.Ship Via}," &quot+1)

Replacing {Bob.Ship Via} with your field/formula.

-k

 

[darwin101]

works great thanks I guess this could be used for more advanced pattern matching, something new to play with.
Thanks again!

 

[synapsevampire]

Note that if a space is not located, everything is returned.

-k