Hello experts,

I am trying to read a line from a csv file that contains '.doc' and print the second column in all caps.

e.g.

My csv file contains:
Test.doc|This is a Test|test1|tes,t2|test-3
Test2.pdf|This is a Second Test| test1|tes,t2|t-est3

while read line
do
echo "$line" | awk -F '|' '/.doc/ {print toupper($2)}'
done < $dataFile


output:
This is a Test


I've been trying to use the toupper function of awk but it does not convert to upper case.

Anyone know another way this can be done?


thanks

Hate to tell you this, but it worked for me on an AIX box. I cut and paste your code as is.

Perhaps, if you are on Solaris, try nawk instead.

Wouldn't it be simpler to just do:

awk -F '|' '/[.]doc/ {print toupper($2)}' datafile

Hi.

It worked for me as well:

#!/usr/bin/env sh

# @(#) a1       Demonstrate awk toupper function.

set -o nounset
echo

## Use local command version for the commands in this demonstration.

echo "(Versions displayed with local utility \"version\")"
version >/dev/null 2>&1 && version bash awk

echo

# Use nawk or /usr/xpg4/bin/awk on Solaris.

cat >data1 <<'EOF'
Test.doc|This is a Test|test1|tes,t2|test-3
Test2.pdf|This is a Second Test| test1|tes,t2|t-est3
EOF

FILE=${1-data1}

echo
echo " Input file $FILE:"
cat $FILE

echo
echo " Results from awk:"
awk -F '|' '
/.doc/ {print toupper($2)}
' $FILE

exit 0

% ./a1

(Versions displayed with local utility "version")
GNU bash 2.05b.0
GNU Awk 3.1.4


 Input file data1:
Test.doc|This is a Test|test1|tes,t2|test-3
Test2.pdf|This is a Second Test| test1|tes,t2|t-est3

 Results from awk:
THIS IS A TEST

Hi again,


thanks for the feedback...I used nawk as suggested and it worked.

awk -F '|' '/[.]doc/ {print toupper($2)}' datafile

is definitely simpler than what I have...I'm a newbie to unix scripting so I of course made something more complicated than it should be

thanks for the help