Need to generate .csv file

Shell Programming and Scripting
1

I have a csv file with the following data

Please find the attachment - zip

 
 
 
 
12/31/20081/7/20091/14/20091/21/20091/28/20092/4/20092/11/20092/18/20092/25/20093/4/20093/11/20093/18/20093/25/20094/1/20094/8/20094/15/20094/22/20094/29/20095/2/20095/13/20095/20/20095/27/20096/3/20096/10/20096/17/20096/24/20097/1/20097/8/20097/15/20097/22/20097/29/20098/5/20098/12/20098/19/20098/26/20099/2/20099/9/20099/16/20099/23/30099/30/200910/7/200910/14/200910/21/200910/28/200911/4/200911/11/200911/18/200911/25/200923967432967150000000000000000000000000000000000000000000011111111119999999444466661111111113131313141414141111111112121212121212126666555599993333

Can you pls help me to generate .csv file like this

We need to pass three parameters, < source_file> <Desn_file> <Destn_dir>

Can you pls help me with this

 
 
 
 
239674329671512/31/2008023967432967151/7/2009023967432967151/14/2009023967432967150239674329671502396743296715023967432967150239674329671502396743296715023967432967150239674329671502396743296715023967432967150239674329671502396743296715023967432967150239674329671502396743296715023967432967150239674329671502396743296715023967432967150239674329671511/18/20090239674329671511/25/2009011111199999912/31/200841111119999991/7/200941111119999991/14/2009411111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911111199999911/18/2009311111199999911/25/20093

Thanks a lot

2

If you are working truly with a csv file, kindly include a small section of the text file. Also, include a section of what you want output to appear as.
Your original email was confusing (at least to me.)

3

Thanks for your reply

I have attached sample.csv in zip herewith ,

I need to change the first row into the below o/p in Sample.csv file

Like wise it has to do for all the rows

Can you pls help with this

4

The o/p file will be in .csv format..

The sample o/p is attached in excel here

5

I see the following in the attached file:

",,12/31/2008,1/7/2009,1/14/2009,1/21/2009,1/28/2009,2/4/2009,2/11/2009,2/18/2009,2/25/2009,3/4/2009,3/11/2009,3/18/2009,3/25/2009,4/1/2009,4/8/2009,4/15/2009,4/22/2009,4/29/2009,5/2/2009,5/13/2009,5/20/2009,5/27/2009,6/3/2009,6/10/2009,6/17/2009,6/24/2009,7/1/2009,7/8/2009,7/15/2009,7/22/2009,7/29/2009,8/5/2009,8/12/2009,8/19/2009,8/26/2009,9/2/2009,9/9/2009,9/16/2009,9/23/3009,9/30/2009,10/7/2009,10/14/2009,10/21/2009,10/28/2009,11/4/2009,11/11/2009,11/18/2009,11/25/2009"
"239674,3296715,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1"
"239674,3300723,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1"
"239674,3304428,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0"

Please clarify what you want for output.

6

Hi Joe

Pls find it in another excel sheet test_data.xls

Can you pls find it here , work sheet called "Data_toBe_Converted

Thanks

7

Your original file appeared to have three rows of data.
What are you trying to do? I am not asking for you to tell me csv file (or Excel), but functionally what you are trying to do.
For example, are you trying to take the first field of each row and make a new file?