Shell Programming and Scripting

Hii

I have these files , and I want to merge them in an excel file
each file have two columns

file1

Code:

title1
1 1 
2 2 
3 3

file2

Code:

title2
5 5
6 6 
7 7
8 8 
9 9
10 10

file 3

Code:

title3
21 21
22 22
23 23
24 24

i use command below to merge them in a excel file

Code:

paste file* > out.csv

the normal output is ok,but when i put it in an excel file(out.csv), the output become like this

Code:

title1 title2 title3
1  1   5  5    21  21
2  2   6  6    22  22
3  3   7  7    23  23
    8  8   24  24
    9  9
   10 10

but i want this output

Code:

title1 title2 title3
1  1   5  5   21  21
2  2   6  6   22  22
3  3   7  7   23  23
       8  8   24  24
       9  9 
      10 10

each number should be in seprate cells,seprate columns and exactly below each other
but when the size of a file is longer than the previous file, the additional numbers go back to last column and below the previous file numbers,for example numbers 8,9,10 and 24

what can i do????

Your required output is some how misleading.How can title1 or title2 or title3 are on the top of two coumns. Can u specify what exactly you need.

Try this

Code:

paste -d , file1 file2 file3

The comma delimiter might help with the justification in excel

The titles are not important for me. you suppose that without titles
i want to paste columns with diffrent sizes in regular,in an excel file

---------- Post updated at 02:51 AM ---------- Previous update was at 02:47 AM ----------

It doesn't work

Make your three input files to csv .Like


If you have large no of contents place those in excel..it will also create the csv files or else separate the entries with comma.

Then you try joining with paste command...it will work..

paste -d "," file1 file2 file3

It workes but in output, each two columns of files,print in one column.
and when i seprate them with space,again become irregular

If the number of records in each file is same then this approach would work. The problem to tackle here is how to paste files with varying number of records.