13

Copying down first row in to all the below blank rows in a .csv file

view full story
linux-howto

http://www.unix.com – Hi All, I have many of files(.csv) of the format given below. Code: Date,Name,Location 04/02/2012,A,India ,B,China ,C,USA Like this I have 1000's of rows and many columns in all my files. I need a shell script to copy down the Date(in this example column1) to the next 2 rows below(in the same column) also. Required output. Code: Date,Name,Location 04/02/2012,A,India 04/02/2012,B,China 04/02/2012,C,USA Many thanks in advance.. Sidda (HowTos)