Search Results

My requirment is for every record of a particular file I've to check for a record delimeter (e.g. "\n") and if any row doesn't have "\n" then report it in error file .

Please suggest me to go...

Thanks itkamaraj, this has worked. I've added another expression & made it complete.
sed 's/^ *//g;s/ *,/,/g;s/, */,/g;s/ *$//g' <filename>

Thank You,
Manab

Hi All,

I want to trim each columns leading & trailing (like sql trim function) of a ',' separated file..

I've a file like this..

manab , c gi
lucky , home
babu , maa

I want the...

Hi All,

I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file.

I've found many options but doing this using PERL script is the best...

It worked like charm..Thank you so very much for help.. This forum is awesome

Cheers :b:

Yes, my output will be like above..

Hi All,

I've a file like this..

Sheet1
a,1
a,2
a,3
a,4
a,5
Sheet2
a,6
a,7
a,8
a,9
a,10
Sheet3
a,11
a,12
a,13