Converting excel to '|' delimiter

Shell Programming and Scripting
1

Hi All,

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

2

Like this?

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

--ahamed

3

Input data

A|"B,C"|D|E

current script converting

A|B|C|D|E

I required

A|B C|D|E

Let me the any idea

4

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?)

5

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

6 
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