[MS_AccessPros] help with a trimming a string

 

Hi all,

This is probably a simple question but I just can't seem to figure it out!  In my recordset I have a field that is a folder path.  I need to take the folder path and trim off the last folder level.  So I want to take this:

"C:\mainpath\subfolder\subfolder\"

and trim it to:

"C:\mainpath\subfolder\"

The number of subfolders and subfolder names will vary with each record.

Thanks in advance for your help!!!

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___