Shell scripting: Check for a string case insensitive

Question

I have a requirement to check if exists clause for all DROP TABLE statements.

If IF EXISTS clause is not present, the script should print it. Below is my code. It works correctly, However I have to check this for all cases. Below scenario works only for uppercase.

for f in $FILES
do
result=`grep "DROP \+TABLE" "$f" | grep -v "IF \+EXISTS"` # -v inverts the match
if [ ! -z $result ]
then
echo 'IF EXISTS clause not found ' $f ':' $result 
fi
done

echo $f | tr '[a-z]' '[A-Z]'

Leo
– Leo

2018-05-04 12:07:39 +00:00
Commented May 4, 2018 at 12:07 — Leo
– Leo, Commented May 4, 2018 at 12:07

Ronan Boiteau · Accepted Answer · 2018-05-04 12:03:32Z

1

You can use grep's -i option:

grep -i "DROP \+TABLE" "$f" | grep -iv "IF \+EXISTS"

From grep's man page:

-i, --ignore-case

Ignore case distinctions in both the PATTERN and the input files. (-i is specified by POSIX.)

answered May 4, 2018 at 12:03

Ronan Boiteau

10.3k7 gold badges39 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Shell scripting: Check for a string case insensitive

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related