paste more than 12 files together - Page 2 - UNIX for Dummies Questions & Answers

jim mcnamara · #8 (**permalink**) 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.

bobo · #9 (**permalink**) 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!

Annihilannic · #10 (**permalink**) 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*

bobo · #11 (**permalink**) 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!

drl · #12 (**permalink**) 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

bobo · #13 (**permalink**) 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

Annihilannic · #14 (**permalink**) 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*

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
paste several files	tonet	Shell Programming and Scripting	1	10-05-2007 07:08 AM
paste 2 files ( it is possible???)	mig28mx	UNIX for Dummies Questions & Answers	3	06-21-2007 08:51 AM
Paste the files contents differently	er_aparna	Shell Programming and Scripting	1	05-16-2007 01:29 AM
Need a Help with paste 2 files since the output is not what i want	alexcol	Shell Programming and Scripting	3	01-09-2007 12:47 AM
awk or sed or paste	leprichaun	UNIX for Dummies Questions & Answers	3	11-16-2003 03:58 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode