return string to left of delimiter... 1

[simon551]

Hi,

In this post, phv helped me to pull data in a query to the right of a separator using the mid and instr functions.

http://www.tek-tips.com/viewthread.cfm?qid=1294210&page=3

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

I'm wondering if anybody knows how to do the same thing but instead of getting the data to the right, we want the data to the left...

 

[PHV]

NewField: IIf(OldField Like '*:*', Left(OldField,InStr(OldField,':')-1), OldField)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[simon551]

gracias, PHV!