Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.scripting.vbscript,microsoft.public.excel.programming,microsoft.public.office.developer.automation
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External File Paths | Excel Programming | |||
excel file paths | Excel Discussion (Misc queries) | |||
Using Variables for file paths in QueryTables.Add | Excel Programming | |||
How do I do a vlookup that links to file paths within a cell ref | Excel Worksheet Functions | |||
file paths | Excel Discussion (Misc queries) |