I need to delete the first row of the CSV file.
In my script I received CSV file as argument and it's first row contains some unwanted data. So I need to remove the first row only before processing it.
See Question&Answers more detail:osI need to delete the first row of the CSV file.
In my script I received CSV file as argument and it's first row contains some unwanted data. So I need to remove the first row only before processing it.
See Question&Answers more detail:osI'd do something like this:
Set fso = CreateObject("Scripting.FileSystemObject")
Set csv = fso.OpenTextFile(WScript.Arguments(...))
If Not csv.AtEndOfStream Then csv.SkipLine 'skip first row
Do Until csv.AtEndOfStream
line = csv.ReadLine
'process read line
Loop
csv.Close
Of course you could just as well do a ReadLine
without processing the returned value for skipping the first line, as Ekkehard.Horner suggested, but IMO SkipLine
better reflects the semantics.