1

Format csv file

view story
linux-howto

http://www.unix.com – Hi, I need to make some changes in a csv file using awk or perl. Unfortunately, all my attempts have led to nothing so I hope you guys can help me. I have the following example input file including header(original file has 35 fields): Code: ABC: DE Time: 2012/09/07 ,"Notional","Name","POS","TEST;Field1","TEST;Field2" "TestField1",0.0000 XYZ,NameField,PosField,"0.00 XYZ","0.00 XYZ" "TestField2",0.0000 XYZ,NameField,PosField,"0.00 XYZ","0.00 XYZ" The first column is called " (HowTos)