GREP in VBA
 

Does any one know of an implememntation of the UNIX GREP command in Excel
VBA? I need to interpret GREP commands and perform any required file piping.

Thanks in Advance
--
Gary's Student

GREP in VBA
 

Don't know if there are any VBA implementations of grep, but if you're
using MacXL, you can take advantage of MacOS being Unix-based to use the
built-in MacScript() method to run an Applescript string which calls the
Unix shell: do shell script "grep expr file", e.g.:

Dim str As String
str = MacScript("do shell script ""egrep 'ab|cd' fname""")

In article ,
"Gary's Student" wrote:

Does any one know of an implememntation of the UNIX GREP command in Excel
VBA? I need to interpret GREP commands and perform any required file piping.

GREP in VBA
 

Thanks for your reply. I may be forced to look at the C code for GREP.
Sadly i suspect that,in this case, plagerism is no less work than doing it
myself.

Thanks again
--
Gary's Student


"JE McGimpsey" wrote:

Don't know if there are any VBA implementations of grep, but if you're
using MacXL, you can take advantage of MacOS being Unix-based to use the
built-in MacScript() method to run an Applescript string which calls the
Unix shell: do shell script "grep expr file", e.g.:

Dim str As String
str = MacScript("do shell script ""egrep 'ab|cd' fname""")

In article ,
"Gary's Student" wrote:

Does any one know of an implememntation of the UNIX GREP command in Excel
VBA? I need to interpret GREP commands and perform any required file piping.

GREP in VBA
 

A quick google search turned up many hits for windows and DOS versions of
GREP.

--
Regards,
Tom Ogilvy


"Gary's Student" wrote in message
...
Thanks for your reply. I may be forced to look at the C code for GREP.
Sadly i suspect that,in this case, plagerism is no less work than doing it
myself.

Thanks again
--
Gary's Student


"JE McGimpsey" wrote:

Don't know if there are any VBA implementations of grep, but if you're
using MacXL, you can take advantage of MacOS being Unix-based to use the
built-in MacScript() method to run an Applescript string which calls the
Unix shell: do shell script "grep expr file", e.g.:

Dim str As String
str = MacScript("do shell script ""egrep 'ab|cd' fname""")

In article ,
"Gary's Student" wrote:

Does any one know of an implememntation of the UNIX GREP command in
Excel
VBA? I need to interpret GREP commands and perform any required file
piping.