I will be getting a file with fixed width format.
Here i need to develop an utility in such a way that if i give the file name,then the script should generate 2 files,one with the data seperated by commas and the other file file with the metadata information.
assume that this is my input file:
the output should be like this
This is how the output should look like.
And the script should not be specific to this file,whatever the file i should be able to generate 2 files (commma seperated,metadata).
please give me some suggestions,how this can be done,with this there might be spaces in the data so the utility should be able to take that into consuderation.its urgent
I am not that good in shellscripting,so please be elaborative with ur answers
so that i can understand.
Thank u very much for ur help.
Could me help me in writing a scrpit that is generalised in a way that whatever the file i give as an input(fixedwidth format files) the outputfile should be comma delimited,and there should not be any header and footer,this should work for any number of columns.can u also suggest me what should be done if there is no data in a column.For now if there is no data the next column value is sitting next to the comma.