Adding field/column to a CSV file

[arun10427]

Hey all,
Can someone tell me how I could add field/column to a CSV file?

 

[Zhris]

Hello

- Read the CSV file in line by line.
- Change one line at a time to include the new field/column.
- Append one line at a time to a new CSV file.
- At the end rename the new CSV file.

Chris

 

[stevexff]

Do as Zhris says, but use Text::CSV_XS to parse the file...

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[feherke]

Hi

how I could add field/column to a CSV file?

Taking the problem as simple as you described it, there is no need to parse the file :

perl -i -pe 's/$/,new/' file.csv

Of course, a more detailed description of the task may affect the solutions we suggest...

Feherke.

http://free.rootshell.be/~feherke/