[AccessD] Parsing Strings

Terri
 
Use the Right function. I'm never sure which way the syntax goes but it's
something like
 
Right([string],6)
 
Roz

-----Original Message-----
From: Terri Jarus [mailto:jarus at amerinet-gpo.com] 
Sent: 03 February 2003 14:22
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/82c01faa/attachment-0002.html>