LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.scripting.vbscript,microsoft.public.excel.programming,microsoft.public.office.developer.automation
external usenet poster
 
Posts: 2
Default RegExp to Parase File paths

Please help me identify the proper pattern to parse a path such that i
capture all the defined directories and file title. I would like to avoid the
slashes and the dot from being recorded.

Per se I have the path:
c:\data\pictures\instru.bmp

I would like the RegExp to return 4 items: c:,data,pictures,instru.
As a starting point I tried:(?:[\\])(^[\\])

This returns nothing. Can you please help me fix this? Also, please advise
how do I work the period into the pattern?

Thank you very much for your help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
External File Paths Stuart[_3_] Excel Programming 6 September 18th 06 06:10 PM
excel file paths Jane Excel Discussion (Misc queries) 1 August 17th 06 04:59 PM
Using Variables for file paths in QueryTables.Add Zik Excel Programming 0 July 25th 06 03:42 PM
How do I do a vlookup that links to file paths within a cell ref Foozy Excel Worksheet Functions 2 July 13th 06 11:32 AM
file paths hr Excel Discussion (Misc queries) 0 December 7th 05 04:59 PM


All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"