CSV data format manipulation

view story

http://www.unix.com – Hi There I need a script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file. I am using an application that will only take data in a particular format and need something that will convert without manual intervention. The original data is in sample 1.csv and final output should look like something in sample 2.csv The very first line should start with a "ONE record," and should break after 9 commas. Then a "Child Record" should be created followed by the renaming characters from 9th comma on. I (HowTos)