Shell Programming and Scripting

Hi all

im having trouble starting with a shell script, i hope someone here can help me

i have 2 files

file1:

404905.jpg 516167
404906.jpg 516168
404917.psd 516183
404947.pdf 516250

file2:

516250 /tmp/RecyclePoster18241.pdf
516167 /tmp/ReunionCardFINAL.jpg
516168 /tmp/MPP-3013594-05012009/ReunionBack.jpg
516183 /tmp/Stamp8x5.psd

my output woulbe like:

ouput:

516250 516250 /tmp/RecyclePoster18241.pdf
516167 404905.jpg /tmp/ReunionCardFINAL.jpg
516168 404906.jpg /tmp/MPP-3013594-05012009/ReunionBack.jpg
516183 404917.psd /tmp/Stamp8x5.psd

note that file1 and file2 is not in particular order it could be
516183 404917.psd
404947.pdf 516250

and so on... although numbers 516183 and 404947 are unique which can be use as an identifier for the output

thanks in advance

Where exactly do you need to replace any line? As far as your example goes, you just want a numerical sort on file2.

hi thanks for the reply,

example in line 1 of file1 which is:
404905.jpg 516167

i need to replace 404905.jpg with /tmp/ReunionCardFINAL.jpg using file2 line which would result in

516167 /tmp/ReunionCardFINAL.jpg


although lines may not be in order, im not sure if while read statement can do job but anything
similar to the output is fine

Again, if your file1 is

Code:

404905.jpg 516167
404906.jpg 516168
404917.psd 516183
404947.pdf 516250

and file2 is

Code:

516250 /tmp/RecyclePoster18241.pdf
516167 /tmp/ReunionCardFINAL.jpg
516168 /tmp/MPP-3013594-05012009/ReunionBack.jpg
516183 /tmp/Stamp8x5.psd

I don't see any difference between your desired output and what sort -n file2 would produce.

Please be a bit more precise on what you want/need to do.

ahh yes, sorry for that

file1:

404905.jpg 516167
404906.jpg 516168
404917.psd 516183
404947.pdf 516250

file2:

516250 /tmp/RecyclePoster18241.pdf
516167 /tmp/ReunionCardFINAL.jpg
516168 /tmp/MPP-3013594-05012009/ReunionBack.jpg
516183 /tmp/Stamp8x5.psd

ouput:

516250 404947.pdf /tmp/RecyclePoster18241.pdf
516167 404905.jpg /tmp/ReunionCardFINAL.jpg
516168 404906.jpg /tmp/MPP-3013594-05012009/ReunionBack.jpg
516183 404917.psd /tmp/Stamp8x5.psd

if you have Python can able to use it, here's an alternative solution

Code:

#!/usr/bin/env python
d={}
for line in open("file1"):
    line= line.strip().split()
    d[line[-1]]=line[0]
for line in open("file2"):
    line= line.strip().split()
    print line[0],d[line[0]],''.join(line[1:])

output:

Code:

# ./test.py
516250 404947.pdf /tmp/RecyclePoster18241.pdf
516167 404905.jpg /tmp/ReunionCardFINAL.jpg
516168 404906.jpg /tmp/MPP-3013594-05012009/ReunionBack.jpg
516183 404917.psd /tmp/Stamp8x5.psd

Use gawk, nawk or /usr/xpg4/bin/awk on Solaris:

Code:

awk 'NR == FNR { _[$2] = $1; next }
$1 = $1 FS _[$1]' file1 file2