Search Results

Yes. As era mentioned you can try something like below:

$paste abc.xls bbc.xls > xyz.xls

output
-----
Eno Ename Eno Ename
101 hello 201 delhi
102 hero 202 Hyd
103 india ...

Hi Ygor(Moderator)..

Your solution is working...
Thank you..

Hi era,

Sry. I can't use perl..

Thank you.
Ram

Vijay,

The following is the output.

$ sed 's/\",/|/g' sample.dat | sed 's/\"//g'
I|+2007,SANDA, 20, MARTIN PLACE|SANDA 20MARTIN
D|+2008,RANDA, 22, MARTIN PLACE|RANDA 22MARTIN

Not exactly...

Hi,
Thank you for the solution.

But, I would like to know how to do it in a shell script.

Regards,
Ram

Hi,

Can you please help me?

How to Parse a comma delimited and optionally quotes dimilited file?

sample.dat
----------
"I",+2007,"SANDA, 20, MARTIN PLACE","SANDA 20MARTIN" ...