Shell Programming and Scripting

Hi All,


Can you please suggest me how to convert excel format to ‘|' delimiter file. I need to use perl script
Thanks
Rama

Like this?

Code:

root@bt> cat infile
a,b,c,d
root@bt> perl -pne 's/,/|/g' infile
a|b|c|d

--ahamed

Input data

Code:

A|"B,C"|D|E

current script converting

Code:

A|B|C|D|E

I required

Code:

A|B C|D|E

Let me the any idea

Raw Microsoft Excel format is unsuitable for processing in any text-based computer language. You can use Excel to export the data with a pipe delimiter. If you have already exported the data in some text file format, please post a representative sample (blotting anything confidential with X's).

(Posts crossed - I had not seen post #3. Was that format written by Microsoft Excel? If so, how?)

Actually I need to convert file name (sample.xls) to “|” delimiter format
Could you please update me the script

Code:

perl -pne 's/,/ /g;s/"//g' infile

This will work for the data provided. But may fail for actual data if there are quotes within the data

--ahamed