threp wrote:
Quote:
> Hi,
> 1. I'm looking for the fastest way to open a CSV file that is full of
> quotes, zap all the quotes, and then close it.
> 2. I 'm also looking for a compiler to make that script into an exe file .
> The exe would need to grab a filename from the command line.
>
> Any ideas ?
'NoQuotes.vbs
'Usage: cscript /nologo NoQuotes.vbs path_to\YourFile.cvs
Set objArgs = WScript.Arguments
If objArgs.Count = 0 Then Wscript.Quit
filename = objArgs(0)
Const ForReading = 1, ForWriting = 2
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile (filename, ForReading, True)
txt = f.ReadAll
Set f = fso.OpenTextFile (filename, ForWriting, True)
f.Write Replace(txt, Chr(34), "")
f.Close
Sorry, can not help with item 2.
--
Todd Vargo
(Post questions to group only. Remove "z" to email personal messages)