Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
using regular expressions to find text in a file
Hi Guys, i think i've got it. '********************************************************************************* ' open file and remove esc characters '********************************************************************************* Set objFSO = CreateObject("Scripting.FileSystemObject") Set... -
using regular expressions to find text in a file
Ok, so using my limited knowledge, you're saying i need to use an ADODB stream to read the file in the correct format and then run my pattern test against that? in which case i've come up with this: 'Script to get OGi ref from file contents 'JH 12/11/2009... -
using regular expressions to find text in a file
@ Strongm, thanks that makes sense. @HarleyQuinn, sorry i didnt notice that what i pasted was not the same. So i will need to use regular expressions to replace the ASCII with "". Something like the below. '*********************************************************** ' open file and remove... -
using regular expressions to find text in a file
what did you change in the code? -
using regular expressions to find text in a file
below is an excerpt from the second file ____________________________________________________________ E&k*p88x2310YReason*p242x2310Yfor*p310x2310Yissue*p1588x2310 YIssue*p1702x2310YDate*p90x2703YAdditional Information*p41x3174YPlease check the information on the schedule is correct... -
using regular expressions to find text in a file
Hi all, Yeah, know at the moment it only picks up the first instance of the pattern but that shouldn't be a problem any further matches will be the same. I'm more worried about instances where it says there are no matches when a simple notepad text search can find it... -
using regular expressions to find text in a file
Thanks for the help, yeah I noticed that I've made some amendments and cleaned it up its working a lot better but when I check the source file there are still instances where the pattern exists but is not being picked up. 'Script to get OGi ref from file contents 'JH 11/11/2009... -
using regular expressions to find text in a file
Hi All, I'm using a script to analyze a file to get a reference from the text, this is what ive got so far ************************************************************ 'script to find OGI ref in a file dim colmatches Const ForReading = 1 Const ForWriting = 2 Set objRegEx =...
