L
L Mehl
I have an awk script to process a text file before importing it. The script
strips rows from the text file after hitting a line containing only " ".
This works from the DOS prompt in c:\filepath\:
c:\filepath\awk95 "/^ $/{nextfile} 1" c:\filepath\input.txt >
c:\filepath\output.text
The following does not work:
strAWKCommandLine = _
"c:\filepath\awk95 " & Chr(34) & "/^ $/{nextfile} 1" & Chr(34) & "
c:\filepath\input.txt > c:\filepath\output.text"
Shell(strAWKCommandLine,1)
Another question:
While debugging this, how can I keep the DOS window open so I can see any
error messages?
An example I saw used "/k" :
Shell(Environ$("comspec") & " /k yourfile.bat", vbNormalFocus)
I can't get that code structure to work.
Thanks for any help on using Shell or keeping the DOS window open
Larry Mehl
strips rows from the text file after hitting a line containing only " ".
This works from the DOS prompt in c:\filepath\:
c:\filepath\awk95 "/^ $/{nextfile} 1" c:\filepath\input.txt >
c:\filepath\output.text
The following does not work:
strAWKCommandLine = _
"c:\filepath\awk95 " & Chr(34) & "/^ $/{nextfile} 1" & Chr(34) & "
c:\filepath\input.txt > c:\filepath\output.text"
Shell(strAWKCommandLine,1)
Another question:
While debugging this, how can I keep the DOS window open so I can see any
error messages?
An example I saw used "/k" :
Shell(Environ$("comspec") & " /k yourfile.bat", vbNormalFocus)
I can't get that code structure to work.
Thanks for any help on using Shell or keeping the DOS window open
Larry Mehl