Shell Programming and Scripting

awk '{if($2 ~ "^[a-zA-Z]"){print $1,substr($3,length($3),1)}}' input_file

awk '{if($2 ~ "^[a-zA-Z]"){print $1,substr($3,length($3),1)}}' input_file

awk ' { if ( $2 ~ "[^a-zA-Z]" ) {print $1,substr($3,length($3),1)}}' ./output.txt | while read a b
do
echo $a
echo $b 
done

awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: bailing out near line 1

sqlplus -s /nolog |&
print -p "connect $db_user/$db_pwd@$db_sid;"
print -p "SPOOL output.txt;"
while read var_ack_party_name
do
print -p "set pagesize 0 feedback off verify off heading off echo off linesize 100 \n"
print -p "select *  from bus_event where ack_party_name like 'MOVE_USAGE_DAEMON%' and event_data_text like '%"$var_ack_party_name"%';"
done <./$1.txt

nawk '{if($2 ~ "^[a-zA-Z]"){print $1,substr($3,length($3),1)}}'  ./output.txt | while read a b