| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
String Parse
Chip
you rock J -----Original Message----- J, Use the InStrRev function to find the last '/' character, then use Mid to get the remaining portion of the string. E.g., Dim strFileUrl As String Dim TrimmedURL As String Dim Pos As Integer strFileUrl = "http://www.web.com/doc.doc" Pos = InStrRev(strFileUrl, "/") TrimmedURL = Mid(strFileUrl, Pos + 1) Debug.Print TrimmedURL -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "J" wrote in message ... Greetings All Could someone help me figure out a working model to trim a file being offered as a string in a URL? Example: strFileUrl = http://www.web.com/doc.doc so that something like strTrimmedURL (variable) would be available? The goal would be for strTrimmedURL to = doc.doc Please advise. J . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parse A String into Two | Excel Worksheet Functions | |||
| parse text string | Excel Worksheet Functions | |||
| Parse this string | Excel Discussion (Misc queries) | |||
| How to parse a string with a date? | Excel Worksheet Functions | |||
| Q: parse string | Excel Discussion (Misc queries) | |||
Threaded Mode
