Shell Programming and Scripting

Duplicate post:

Code:

sed 's|export mibs =\opt\mymibs\|export mibs =\opt\new_mibs\|g' export.txt

-Devaraj Takhellambam

I am trying to modify the code above for a similar situation. I have two input files. The first file (Datastores) is a CSV with friendly names in the first column and UUIDs in the second column. The second file (VMs) is a list of files with the full path using the UUID. For example:

----- datastores.csv -----
friendly name 1, UUID1
friendly name 2, UUID2
friendly name 3, UUID3
etc
----- datastores.csv -----

----- VMs.txt -----
/folder/UUID3/vm1.vmx
/folder/UUID2/vm2.vmx
/folder/UUID1/vm3.vmx
/folder/UUID3/vm4.vmx
etc
----- VMs.txt -----

What I am looking for is output that looks like this:

----- output.txt -----
/folder/friendly name 3/vm1.vmx
/folder/friendly name 2/vm2.vmx
/folder/friendly name 1/vm3.vmx
/folder/friendly name 3/vm4.vmx
etc
----- output.txt -----

The sample awk is not intuitive for me even after reading the other explanation and going over the O'Rielly pocket reference. The case of either input does not need to be changed -- if there is a problem with case matching then I have other issues to deal with.

Thanks for your help in advance.

Code:

nawk 'NR==FNR {
_[toupper($1)]=$2
next
}
NR!=FNR{
	printf("1 %s tf %s\n",_[toupper($1)],$2)
}' file1 file2