<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4916.2300" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 10pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV><SPAN class=921242414-04022003>Well, you could just manually parse each
character in the string going backwards:</SPAN></DIV>
<DIV><SPAN class=921242414-04022003></SPAN> </DIV>
<DIV><SPAN class=921242414-04022003>Function ReturnLastWord(ByVal strIn As
String) As String</SPAN></DIV>
<DIV><SPAN class=921242414-04022003></SPAN> </DIV>
<DIV><SPAN class=921242414-04022003> Dim lngCtr As
Long</SPAN></DIV>
<DIV><SPAN class=921242414-04022003></SPAN> </DIV>
<DIV><SPAN class=921242414-04022003> For lngCtr = Len(strIn)
To 1 Step - 1</SPAN></DIV>
<DIV><SPAN class=921242414-04022003>
If Mid$(strIn, lngCtr, 1) = " " Then</SPAN><SPAN
class=921242414-04022003> </SPAN></DIV>
<DIV><SPAN
class=921242414-04022003>
ReturnLastWord = Mid$(strIn, lngCtr + 1)</SPAN></DIV>
<DIV><SPAN
class=921242414-04022003>
Exit Function</SPAN></DIV>
<DIV><SPAN class=921242414-04022003>
End If</SPAN></DIV>
<DIV><SPAN class=921242414-04022003> Next lngCtr</SPAN></DIV>
<DIV><SPAN class=921242414-04022003></SPAN> </DIV>
<DIV><SPAN class=921242414-04022003>End Function</SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT
face=Tahoma>-----Original Message-----<BR><B>From:</B> Terri Jarus
[mailto:jarus@amerinet-gpo.com]<BR><B>Sent:</B> Tuesday, February 04, 2003
8:20 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] Parsing Strings-UPDATE<BR><BR></FONT></DIV>
<DIV>This was exactly what I needed. However, InStrRev is not available
in 97 - I have both 97 and XP, so was able to extract what I needed. How
would it work for 97 though??</DIV>
<DIV> </DIV>
<DIV>Thanks again for the help. I have a mental block about a lot of
things - working with strings tops the list. I am keeping the solution
for future reference.<BR><BR>>>> BBarabash@tappeconstruction.com
02/03/03 09:07AM >>><BR></DIV><FONT face="MS Sans Serif">
<DIV><SPAN class=312260615-03022003>Oops!</SPAN></DIV>
<DIV><SPAN class=312260615-03022003>I meant to say:</SPAN></DIV>
<DIV><SPAN class=312260615-03022003>
<DIV><SPAN class=531545714-03022003><SPAN
class=312260615-03022003>Mid</SPAN>$(MyString,InStrRev(MyString,"
")+1)</SPAN></DIV>
<DIV><SPAN class=531545714-03022003></SPAN> </DIV>
<DIV><SPAN class=531545714-03022003><SPAN class=312260615-03022003>(looks like
somebody has a case of the Mondays)</SPAN></SPAN></DIV></SPAN></DIV>
<DIV> </DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT
face=Tahoma>-----Original Message-----<BR><B>From:</B> Brett Barabash
<BR><B>Sent:</B> Monday, February 03, 2003 9:00 AM<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE: [AccessD] Parsing
Strings<BR><BR></FONT></DIV>
<DIV><SPAN class=531545714-03022003>Hi Terri,</SPAN></DIV>
<DIV><SPAN class=531545714-03022003>If you are trying to extract the last word
from the string, you could use InStrRev to do this:</SPAN></DIV>
<DIV><SPAN class=531545714-03022003>Right$(MyString,InStrRev(MyString,"
")+1)</SPAN></DIV>
<DIV><SPAN class=531545714-03022003></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT
face=Tahoma>-----Original Message-----<BR><B>From:</B> Terri Jarus
[mailto:jarus@amerinet-gpo.com]<BR><B>Sent:</B> Monday, February 03, 2003
8:22 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] Parsing Strings<BR><BR></FONT></DIV>
<DIV>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:</DIV>
<DIV> </DIV>
<DIV>FLDR T TAB M CLIP#5 BLUE 11PT; 2 PLY STRAIGHT CUT 250/CS</DIV>
<DIV> </DIV>
<DIV>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.
</DIV>
<DIV> </DIV>
<DIV>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.</DIV></BLOCKQUOTE></BLOCKQUOTE></FONT></BODY></HTML>