select a portion of a text field 1

[simon551]

Hi,

I'm trying to extract text that occurs after a specific symbol in a field.

specifically: I'm trying to select the text after a ":" where a ":" (colon) is present.

For example if the field contains Star:North Star, I want the query result to be North Star. But if the field contains Star, the result should be Star.

I don't even know this is possible.

Any ideas?

Thanks,
simon

 

[PHV]

NewField: IIf(OldField Like '*:*', Mid(OldField,1+InStr(OldField,':')), OldField)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[simon551]

Your still the best, PHV!

Thank you once again!