Help with a query

  • Thread starter Thread starter Terrence Carroll
  • Start date Start date
T

Terrence Carroll

How do I get my query to return all of the text to the right of the ~
character. For instance for the following string "Terms Template ~ Bob's
Communications" I just want Bob's Communications to appear.

Thanks,

Terry Carroll
 
Can you guarantee there always will be a '~' character?
You can use the INSTR() function to find the position of the squiggle, then
the MID() function to take the portion of the string from that position.
I think this will do it (wont work if squiggle is missing).
MID(MyString,INSTR(MyString,'~')+1)
Look these functions up in Help.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
If there is a space after the tilde, use:
MID(MyString,INSTR(MyString,'~')+2)

Steve
(e-mail address removed)
 
Back
Top