Shell Programming and Scripting

change this:

Code:

sed -n 's/[/]/:/gp' < associates > assoc_colon

to this:

Code:

sed -e 's#/#:#g' < associates > assoc_colon

Tried it - no luck with that too.

Code:

join -t: -1 3 -2 1 sept_colon assoc_colon > sept_assoc

or given this and the sample files:

Code:

 join -t: -1 3 -2 1 -o 1.1 -o 1.2 -o 2.2 -o 2.4 sept_colon assoc_colon

here's what I get:

Code:

104:9:John Doe:Clerk
104:9:John Doe:Clerk
112:1:Susan Smith:Manager
112:1:Susan Smith:Manager
104:2:Fast Buck:Stock Boy
104:2:Fast Buck:Stock Boy
104:2:Fast Buck:Stock Boy
104:2:Fast Buck:Stock Boy
104:1:Aimee Woods:Secretary
104:1:Aimee Woods:Secretary

there must be something else at work here. I hand executed each line of my script to get to the _colon files, replacing my command with your command. Still the result of my join is empty

This is really annoying, only because I can find nothing wrong with the syntax. there must be some specification as input to join that I am missing.

On a seperate matter, why would join not output values correctly? Given a join on field one for both files, if I have a:
-o 1.1 -o 1.2 -o 1.3 -o 2.1 -o 2.2, why is it overwriting the first field with the 2.2 and dropping both index fields? I can output either file correctly (all fields) it just fails on putting out both files fields.

Now I know why I moved on to relational DB's LOL

seems like it's working ok for me .......
the 'sept_assoc' file contains the correct [it seems] join....

Well I think the problem is quite simply - the original files have messed up linefeeds/CR anddon't play well. I reentered the files (with a common separator) and they work fine - now I'll try them with different ones and see what happens.

Thanks for everyones help. Now if only I can figure out where the extra chars are sneaking in.

8)

if somehow you're ftp-ing file between UNIX and Windoz, make sure you do so in ASCII format.