Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is it TRIM? 1

Status
Not open for further replies.

lengoo

IS-IT--Management
Jan 15, 2002
381
GH
Hi All,
I am trying to truncate the first 3 characters of a string.. is the command I need TRIM? How do I use it?

eg d:\file_system.doc

I want to trim the d:\ bit and only get file_system.doc

Thanks :)
 
You can use the Right function, as below:

strNew = right(strFilePath,len(strFilePath)-3)

where strFilePath is the string you want to manipulate. This will give you all the string without the first 3 characters.

Dan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top