If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
Select specific text in cell
Sorry, but I am not up to speed on my RegEx yet... would that retain the
c: from the front of the path or not? If there were no "\" after the C:, then it would be retained. But if the C: represents a drive, is C:filename legal? OR must it be C:\filename Yes, c:filename is legal. In the flurry of postings we have done, you missed my 2:40PM (EST) message. I am repeating it here so you don't have to look for it... see my test() subroutine and note in particular the path/filename used in the Open statement. Expanding -- it would certainly be possible for a parser in which the "\" preceding the filename was optional Which is, of course, a possibility; though, in today's type file referencing, somewhat rare. If the default path is at the directory where the file is located, then you can legally specify the file using something like this... c:filename.ext and the operating system will look in the current directory. On my system, there is a directory called TEMP at the root level of my C: drive. In that directory is a file named Test.txt. The following code (showing a 'backslashless' path reference) prints the first line of the file into the Immediate window... Sub test() ChDir "c:\temp" Open "c:test.txt" For Input As #1 Line Input #1, LineOfText Close #1 Debug.Print LineOfText End Sub Rick Well, as written, the regex would retain the C:. If you wanted to return filename without the C:, it would be a simple alteration in the regex: re.Pattern = "([^\\:]*\S)\s?-[^\\]*$" This is a bit more robust, though: re.Pattern = "([^\\:]*\S)\s*-[^\\]*$" I wouldn't worry about it. Even though it is legal to have a path with no backslashes, almost no one does so anymore as it requires some mechanism to change the active directory path in order to use it. One would hardly store paths in that format with the requirement that to use them, a certain path has to be made active. Rick |
Thread Tools | |
Display Modes | |
|
|