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

In message . com, Tue,
31 Oct 2006 14:05:28, Tom Lavedas writes

Personally, I like using the Split function for this (I haven't played
with Regular Expressions much


Then you should.

It is impossible to advise correctly and justifiably on the proper
coding of string manipulations without an adequate understanding of the
use of RegExps (assuming that they exist in the language in question and
that a known non-trivial subset is correctly implemented).

And, if you are an active coder of such things on your own behalf, and
are not reasonably acquainted with RegExps, the time wasted will include
your own.



But in this case, if VBS RE's match Javascript ones, the OP may consider
and translate
F.X0.value.split(".")[0].split("\\")
which gives the right result for the OP's string in control F.X0.

It's a good idea to read the newsgroup and its FAQ. See below.

--
(c) John Stockton, Surrey, UK. Turnpike v6.05 IE 6
<URL:http://www.jibbering.com/faq/? JL/RC: FAQ of news:comp.lang.javascript
<URL:http://www.merlyn.demon.co.uk/js-valid.htm jscr RegExps & Validation.
<URL:http://www.merlyn.demon.co.uk/ TP/BP/Delphi/jscr/&c, FAQ items, links.
 
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 10:27 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"