I just got it to work:

Code:

myResult=$(awk -F"\t" -v lookupVal="$luVal" '$1 == lookupVal { print $2 }' "$inputFile")

I had to use "\t" for the tab character syntax.

Thanks for all your help.

James

Moderator's Comments:

Code tags, please...

---------- Post updated at 03:04 PM ---------- Previous update was at 02:24 PM ----------

I am working OSX. When I create my data table in Excel and save it as a tab delimited file, the default line delimiter is a MAC Carriage return "\r"

I looked through the man page and some other sources on line and I don't see an option to set the record separator "-RS" from the command line the same way we used "-F" to set the field separator.

Here is my working code (Assuming UNIX line feeds)

Code:

assetTypeHandling=$(awk -F"\t" -v lookupVal="$assetType" '$1 == lookupVal { print $2,$3,$4,$5 }' "$assetTypeMapFile")

I tried

Code:

awk -RS"\r" -F"\t" -v ...

and

Code:

awk RS="\r" -F"\t" -v ...

But both of those result in:

Code:

awk: syntax error at source line 1

Is there some way to feed this line of code "\r" as the record separator?