[AccessD] Parsing Strings-UPDATE

Oops!
I meant to say:
Mid$(MyString,InStrRev(MyString," ")+1)
 
(looks like somebody has a case of the Mondays)
 
-----Original Message-----
From: Brett Barabash 
Sent: Monday, February 03, 2003 9:00 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Parsing Strings


Hi Terri,
If you are trying to extract the last word from the string, you could use
InStrRev to do this:
Right$(MyString,InStrRev(MyString," ")+1)
 

-----Original Message-----
From: Terri Jarus [mailto:jarus at amerinet-gpo.com]
Sent: Monday, February 03, 2003 8:22 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Parsing Strings


I know this is very easy, but I can never remember exactly how to do this.
I need to parse off some data from the end of a string.  For example, the
string:
 
FLDR T TAB M CLIP#5 BLUE 11PT; 2 PLY STRAIGHT CUT 250/CS
 
I want to parse out "250/CS".  How do I set up the code to do this?  This
info is always going to be at the end of the string.  
 
Thanks for your help.  If there is a website or information that I can put
in my files as to how to work with strings, I could reference that in the
future.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030203/7d8b313b/attachment-0001.html>