paste more than 12 files together


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers paste more than 12 files together
# 8  
Old 08-04-2008
Code:
paste one two three four five six seven eight nine ten eleven twelve > tmp
paste tmp thirteen > final_file

This is what drl told and others told you about a tmp file.
# 9  
Old 08-04-2008
Thanks Jim!

I know this technique already. I am interested in:

somecommand file* (1 command line if possible no PIPE involve)

that will give me the results

1 2 3 4 5 6 7 8 9 10 11 12 13

can awk or some other commands be functioned as paste some how????

Thanks!
# 10  
Old 08-04-2008
Code:
awk '{l[FNR]=l[FNR] $0 OFS} FNR>max {max=FNR} END {for (i=1;i<=max;i++){print l[i]}}' file*

# 11  
Old 08-07-2008
thanks for the reply but it is not working.
Example:

file1
cat file1
1

file2
cat file2
2
3

file3
cat file3
3
4

awk '{l[FNR]=l[FNR] $0 OFS} FNR>max {max=FNR} END {for (i=1;i<=max;i++){print l[i]}}' file*

result show nothing


try it with nawk

nawk '{l[FNR]=l[FNR] $0 OFS} FNR>max {max=FNR} END {for (i=1;i<=max;i++){print l[i]}}' file*

results:
1 2 3
3 4

I need the data:

1 2 3
3 4

Any takers????

Thanks!
# 12  
Old 08-07-2008
Hi.
Quote:
Originally Posted by bobo
thanks for the reply but it is not working ...

nawk '{l[FNR]=l[FNR] $0 OFS} FNR>max {max=FNR} END {for (i=1;i<=max;i++){print l[i]}}' file*

results:
1 2 3
3 4

I need the data:

1 2 3
3 4

Any takers????

Thanks!
To most observers those look exactly the same, hence the requirements are met.

However, what you apparently attempted to type was:
Code:
try it with nawk

nawk '{l[FNR]=l[FNR] $0 OFS} FNR>max {max=FNR} END {for (i=1;i<=max;i++){print l[i]}}' file*

results:
1 2 3
3 4

I need the data:

1   2   3
    3   4

There are 2 lessons to be learned here. For program and data, one needs to use CODE tags around the text. I think you've been around here long enough (100+ posts) to know and start using that.

Secondly, this last requirement was not in your initial requirements. As it turns out, both paste and paste.perl do the right thing with such files.

The awk will need to be augmented to supply a default string when it runs out of lines with your last example file1.

For my purposes, paste and paste.perl solve all the problems. Best wishes ... cheers, drl
# 13  
Old 08-07-2008
i know how to use paste. I can't paste more then 12 files or more. That is why I tried to see any one have other solustions.

nawk '{l[FNR]=l[FNR] $0 OFS} FNR>max {max=FNR} END {for (i=1;i<=max;i++){print l[i]}}' file*

this command is not working
# 14  
Old 08-07-2008
Try this:

Code:
awk '
        FNR==1 { col++ }
        FNR>max { max=FNR }
        { l[FNR,col]=$0 }
        END {
                for (i=1;i<=max;i++) {
                        for (j=1;j<=col;j++) {
                                printf "%-10s",l[i,j]
                        }
                        print ""
                }
        }
' file*

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to paste multiple files in parallel?

Hi all, I am trying to paste thousands of files together into a matrix. Each file has only 1 column and all the files have the same number of rows (~27k rows). I tried paste * > output as well as some other for loops but the output only contains the columns from the 1st and last files. The... (8 Replies)
Discussion started by: notimenocall
8 Replies

2. Shell Programming and Scripting

Paste files of varying lengths

I have three files of varying lengths and different number of columns. How can I paste all three with all columns aligned? File1 ---- 123 File2 ---- 234 345 678 File3 ---- 456 789 Output should look like: 123 234 456 345 789 (6 Replies)
Discussion started by: Un1xNewb1e
6 Replies

3. Shell Programming and Scripting

paste mutiple files in a loop

file1.txt file2.txt file3.txt desired output is each file is in the same directory, hasthe same number of columns but different rows. i want to be able to paste them into one file. thanks! (5 Replies)
Discussion started by: johnkim0806
5 Replies

4. Shell Programming and Scripting

Paste second columns from files to its corresponding file

Hi All, I have two sets of files. One set with extension .txt This set has file names with numbers like these. 1.txt, 2.txt, 3.txt until extactly 100.txt. The .txt files look like these: 0.38701788 93750 0.38622013 94456 0.38350296 94440 0.38282126 94057 0.38282126 94439 0.35847232... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies

5. UNIX for Dummies Questions & Answers

Copy/Paste data in files

Hi, I want to put the following values into Variables R2=0.999863 , V2=118.870318 , D2=-178.887511 and so on. There are six values for each variable R2-R8, V2-V8 and D2-D8, total of 18 values for all the variables. Can any one help me to copy and paste all the values in their respective... (2 Replies)
Discussion started by: sullah
2 Replies

6. Shell Programming and Scripting

Paste the files

Dear All, I have thousands of files (consists of one column each) and i need to paste all the columns in a single file as follows: I have files - file1, file2, file3, .......file2000. I need to paste all the files in a single file of separate columns as shown below: file1 file2 file3 ... (3 Replies)
Discussion started by: Fredrick
3 Replies

7. Shell Programming and Scripting

paste several files

Hi everybody: I tried to paste several files which have the same pattern name file like this: down_s1.dat, down_s2.dat, down_s3.dat, down_s4.dat ... down_s10.dat So I have tried to do it as: paste down_s.dat > final.dat But it does not work correctly. Any suggestion. Thanks in... (1 Reply)
Discussion started by: tonet
1 Replies

8. UNIX for Dummies Questions & Answers

paste 2 files ( it is possible???)

Hello all, I have two files: file1: data1 data2 data3 data4 data5 data6 data7 data8 data9 file2: reference I need to paste both files with the following output: data1 data2 data3 reference data4 data5 data6 reference data7 data8 data9 reference I tried using the paste... (3 Replies)
Discussion started by: mig28mx
3 Replies

9. Shell Programming and Scripting

Paste the files contents differently

Hello , I want to segregate by file contents in a much simpler format ie input file Wednesday May 16 11:59:44 IST 2007 90376 44136 process1 pid1 90200 43208 process1 pid2 90200 43208 process1 pid3 90200 43208 process1 pid4 Wednesday May 16 12:00:45 IST 2007 90376 44136 process1 pid1... (1 Reply)
Discussion started by: er_aparna
1 Replies

10. Shell Programming and Scripting

Need a Help with paste 2 files since the output is not what i want

Need a Help with paste 2 files since the output is not what i want ie: i have 2 files pwd /home/pavargaz/alejo/scan01/nokia/2006/abril/bavaria/chu0 $ cat filechu chu0 dia Cantidad 01 257 02 262 03 260 04 58 $pwd ... (3 Replies)
Discussion started by: alexcol
3 Replies
Login or Register to Ask a Question