TRIMMING FROM A SPECIFIED CHARACTER ONWARDS 1

[ovie52]

I HAVE ENTRIES IN A FIELD IN A TABLE SUCH AS:

5100V#74853769376
4100#8957984768745
5180#89745967

I WANT TO TRIM THEM FROM THE '#' ONWARDS. I.E. SO THEY READ
5100V
4100
5180

CAN ANYONE HELP?

 

[mdthornton]

try this expression:

left([myStr], instr(1,[myStr],"#",1) -1))

this assumes that there will always be a "#" Best Regards,
Mike

 

[B827]

Or does it require:

Right([Mystr],Len([Mystr])-Instr(1,[Mystr],"#&quot)

which will produce
74853769376
8957984768745
89745967
in the above example Sandy

 

[B827]

Oops,
should read more carefully- sorry about that Sandy