Hi,

I have 3 files below

$cat test1
a
b
c

$cat test2
i
j
k

$cat test3
x
y
z

I want to combine all these files into one csv file.

My final file should look like this:

$cat final
a,i,x
b,j,y
c,k,z

please help.

See man paste for future reference.

1 members found this post helpful.

Thanks colucix
I had never heard of paste command in unix. This really helpful command. I was thinking of writing a code to accomplish this. But this command really eased all my presssure.

However I am facing some problem with this command as well.

I ave following two files

$cat account_name
quantsre
fnguide
paclife

$cat success_internal
Internal: 14/07/2008 21:10:58 (10.56.208.18)
Internal: 09/06/2008 13:18:48 (10.2.104.147)
Internal: 07/07/2008 11:52:04 (10.2.200.89)


when i use paste command as specified by you i dont get expected result though

$paste -d, account_name success_internal
,Internal: 14/07/2008 21:10:58 (10.56.208.18)
,Internal: 09/06/2008 13:18:48 (10.2.104.147)
,Internal: 07/07/2008 11:52:04 (10.2.200.89)


whereas expected result was

quantsre,Internal: 14/07/2008 21:10:58 (10.56.208.18)
fnguide,Internal: 09/06/2008 13:18:48 (10.2.104.147)
paclife,Internal: 07/07/2008 11:52:04 (10.2.200.89)

I am using Solaris 5.8, bash shell. I will try it on linux box in some time.

-Ravi

Hi,

I could find out the problem why it was happening.

I had transferred files (account_name and success_internal) from windows machine to solaris. So there was a carriage return character (^M ) at the end of each line. When i used to open it in vi editor it looks like something like this

$vi account_name
quantsre^M
fnguide^M
paclife^M


I deleted these characters with the help of dos2unix command

$dos2unix account_name account_name

And this solved my problem

Thanks,
Ravi

Very good. Indeed, I tested the paste command on Solaris 5.8 and it works as well.