pasting problem

Shell Programming and Scripting
1

Hi Friends,
Please help.
I have 2 pipe delimited files; each one has different number of rows in it. I want to use "paste" to concatenate these files.
However, while doing it, due to difference in number of rows in each files resulting file is in haphazard manner.
E.g.
file 1

Reliance Info|
Golden Gate|

File_2

9820414751
9752412453
020-2456854
02154-245871
8754123567

When I use following command
paste file_1 file_2 >file_3

cat file_3

Reliance Info|9820414751
Golden Gate|9752412453
020-2456854
02154-245871
8754123567

However I want it to look like following in excel after text-to-column.

Reliance Info	9820414751
Golden Gate	9752412453
		020-2456854
		02154-245871
		8754123567

_Anu

2

You can just add "|" to the end of all lines in file2 for this.

 sed 's/$/|/g' file2 > file2_delimited

Then you can use,

 paste file1 file2_delimited > file3

I hope this should solve your problem.