Conversion to uppercase - tr

subrat · #1 (**permalink**) 06-16-2008

Hi,

I am trying to convert the $i in loop from lower to upper case but getting error like ' awk: 0602-502 The statement cannot be correctly parsed. The source line is 1.' ..

Requirement: I have many table in script XXX.sql which starting with 'ABC_','AbC_','aBc_' etc.. same thing for table starting with XYZ. I need all these table names.

Could u plz help me on that.

grep -iE "ABC_|XYZ_" /ukdw/prd/working/TDMatrix/srualcb02/ukdw/prd/bin/XXX.sql | awk '{printf("%s ",$0)}END{print "\n"}' | sed 's/,/ /g;s/ / /g' |
awk 'BEGIN{FS=" "}
{
for(i=1;i<=NF;i++)
{
fieldToCheck= $i | tr '[a-z]' '[A-Z]'
if (index($fieldToCheck,"ABC")>0){print $i};
if (index($fieldToCheck,"XYZ")>0){print $i};
}
}'

nua7 · #2 (**permalink**) 06-16-2008

Code:

fieldToCheck= `echo $i | tr '[a-z]' '[A-Z]'`

Franklin52 · #3 (**permalink**) 06-16-2008

Replace this:

Code:

fieldToCheck= $i | tr '[a-z]' '[A-Z]'
if (index($fieldToCheck,"ABC")>0){print $i};
if (index($fieldToCheck,"XYZ")>0){print $i};

with:

Code:

fieldToCheck=toupper($i)
if (index(fieldToCheck,"ABC")>0){print $i}
if (index(fieldToCheck,"XYZ")>0){print $i}

Regards

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Lowercase to Uppercase	ggovotsis	AIX	7	10-16-2008 11:07 AM
only uppercase first character?	fedora	Shell Programming and Scripting	7	09-26-2008 09:12 PM
make uppercase	kirkm76	UNIX for Dummies Questions & Answers	4	05-29-2007 12:28 AM
Converting to Uppercase	dreams5617	Shell Programming and Scripting	3	11-12-2004 01:44 AM
uppercase to lowercase	webex	Shell Programming and Scripting	4	01-03-2002 02:15 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by