Parsing data

[Guest]

I'm trying to parse the following string of data and pull out the text from
the right to left up until the fist instance of "\".

SAMPLE TEXT:
C:\VCCT Training DB\Excel IO\S M 1\Testing Name Fields.csv

This is actually only a sample of the text I will need to parse. It will
always be a path and file name, always a .csv, but the path and file name
will change.

Much thanks!
Clint Herman

 

[Alex Dybenko]

Hi,
you can use array approach:

s="C:\VCCT Training DB\Excel IO\S M 1\Testing Name Fields.csv"

a=split(s,"\")

?a(ubound(a))

Testing Name Fields.csv


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[John Nurick]

Or if you're using Access 2002 or later,

Mid(strText, InstrRev(strText, "\") + 1)