Shell Programming and Scripting

Say I have 2 files of 2 rows of 3 columns each

file1:

cat catdata1 catdata2
dog dogdata1 dogdata2

file2:

cat catdata3 catdata4
dog dogdata3 dogdata4

and I need to combine both files so that is appears like:

cat catdata1 catdata2 catdata3 catdata4
dog dogdata1 dogdata2 dogdata3 dogdata4

How would I do that? I need the power of awk, but I can't get it to work with 2 files simultaneously.

Code:

join file1 file2

Thanks Reborg,

The join command doesn't seem to work when the join field is a number or date though.

ie.
file1:
2007/04/04 Joey
file2:
2007/04/04 Tabris

join file1 file2
<nothing comes out>

That is strange. I get as I expect:

Code:

2007/04/04 Joey Tabris

What does "uname -a" look like on your machine?

SunOS phxitetl01 5.8 Generic_117350-28 sun4u sparc SUNW,Netra-T12

Actually now that I've tried the example that I've given it does work.

Here's one that doesn't though

file1:

2007/04/04 Joey
john jim

file2:

albert martha
2007/04/04 Jimmy

I don't get it. Is there any way I can look into the tokens that the utility is parsing?

In this case what would the expected output be. When asking questions about data processing you need to give a full example of input(s) and expect output.

I type in
join file1 file2

I would expect the output to be:

2007/04/04 Joey Jimmy
or
2007/04/04 Jimmy Joey
doesn't matter which.

Nothing shows up instead

How do I specify a space as a delimeter.

Like join -t " "
or do I have to use some ascii character like join -t "\0000"