CODEWITHSUNDEEP
vbscript
user1553605
user1553605

Reputation: 1393

How to delete the first row in the .csv file

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.

Upvotes: 1

Views: 4103

Answers (2)

Ansgar Wiechers
Ansgar Wiechers

Reputation: 200293

I'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.

Upvotes: 2

Ekkehard.Horner
Ekkehard.Horner

Reputation: 38745

Do a .ReadLine immediately after opening the input file. This will restrict a later line loop -

Do Until .AtEndOfStream
   .ReadLine
   ... process ...
Loop

or a .ReadAll() to the data from the second line onwards only.

Upvotes: 0

Related Questions