perl parsing csv file

[peterchan75]

Hi all,

I am trying to extract data from csv files.
1. Read each csv file in a single read i.e. not line by line. Using
local $/=undef;
2. Split the file with "\n" delimiter into an array
3. Go through each array element and split the csv string into an array

All these work fine until I hit a string with some values follow a bunch of commas(i.e. no value). The array size stop at the last values and remaining commas with no value are ignored. Is this normal ?

Well... to get thing going... I push blanks until I get the right size.
Bandage job !

 

[u0206397]

See this: https://perlmaven.com/how-to-read-a-csv-file-using-perl

You might have a spreadsheet with certain columns unfilled (empty fields) for certain rows. So they become consecutive commas joined together.

Use Text::CSV for more robust parsing.

 

[peterchan75]

See this: https://perlmaven.com/how-to-read-a-csv-file-using-perl

You might have a spreadsheet with certain columns unfilled (empty fields) for certain rows. So they become consecutive commas joined together.

Use Text::CSV for more robust parsing.

Thank you very much.