Need to know how the CC is getting calculated in the below script

Surya Venkata · 07-06-2017, 01:45 AM

z="KK"
Spt=""
cc=""
count=0
defaultengine="00000"
echo "00000"",00000"",00000"",0000"",000"",00000"",0000"",00000"",00000">>/data/informatica/Services_2/CSASERVICES04/TgtFiles/escalate_data1.out
while read -r line; do
a=`echo "$line"|cut -d ',' -f 1`
b=`echo "$line"|cut -d ',' -f 2`
c=`echo "$line"|cut -d ',' -f 3`
d=`echo "$line"|cut -d ',' -f 4`
e=`echo "$line"|cut -d ',' -f 5`
f=`echo "$line"|cut -d ',' -f 6`
g=`echo "$line"|cut -d ',' -f 7`
h=`echo "$line"|cut -d ',' -f 8`
k=`echo "$h@mail.ad.ge.com"`
i=`echo "$line"|cut -d ',' -f 9`
t="KK"

echo $f>/data/informatica/Services_2/CSASERVICES04/TgtFiles/Echo_special_character.txt
pop=`sed 's/\^/\,/g' /data/informatica/Services_2/CSASERVICES04/TgtFiles/Echo_special_character.txt`
echo $pop>/data/informatica/Services_2/CSASERVICES04/TgtFiles/Echo_special_character.txt
pop=`sed 's/||/\$/g' /data/informatica/Services_2/CSASERVICES04/TgtFiles/Echo_special_character.txt`

if [ $z = $g -o $z = $t ]
then
Spt=$Spt"<tr>
<td> "$a" </td>
<td> "$c" </td>
<td> "$d" </td>
<td> "$e" </td>
<td> "$pop" </td>
<td> "$i" </td>
</tr>"
fi

if [ $z != $g -a $z != $t -o $a = $defaultengine ]
then
cc=$(printf '%s\n' "$cc" | awk -v RS='[,[:space:]]+' '!a[$0]++{printf "%s%s", $0, RT}')
cc="${cc%,*}"
cc=`echo $cc",307009431@mail.ad.ge.com,210026614@mail.ad.ge.com,502301326@mail.ad.ge.com,210077716@mail.ad.ge .com"`

echo "
<html>
<head>
<title>any title</title>
</head>
<body>
Hi, 
For your action below are the details
<table border='2'>
<tr>
<td> ESN </td>
<td> Module </td>
<td> Keyword </td>
<td> Bucket </td>
<td> Comment </td>
<td> Priority </td>
</tr>
"$Spt"

</table>
 
 
WIP Link:<A Href='sc.ge.com/*WIPanalytics'>WIP-ANALYTICS</A> 

Regards 
MCRB Shop Team
</body>
</html>
" | mailx -s "$(echo -e "Engine Escalated\nContent-Type: text/html")" -c $cc $z

Spt="<tr>
<td> "$a" </td>
<td> "$c" </td>
<td> "$d" </td>
<td> "$e" </td>
<td> "$pop" </td>
<td> "$i" </td>
</tr>"

fi
z=$g
if [ $count = 0 ]
then
cc=$k
else
cc=$cc","$k
fi
count=$count+1

done </data/informatica/Services_2/CSASERVICES04/TgtFiles/escalate_data1.out

pan64 · 07-06-2017, 06:03 AM

please use [code]here comes your script[/code] to keep formatting of your script (you can probably edit your original post).
From the other hand insert set -xv at the beginning of your script and you will see what's happening.
There are 5 cc=<something> lines found in this script, which one is unclear?

Surya Venkata · 07-06-2017, 06:43 AM

Quote:

Originally Posted by Surya Venkata

z="KK"
Spt=""
cc=""
count=0
defaultengine="00000"
echo "00000"",00000"",00000"",0000"",000"",00000"",0000"",00000"",00000">>/data/informatica/Services_2/CSASERVICES04/TgtFiles/escalate_data1.out
while read -r line; do
a=`echo "$line"|cut -d ',' -f 1`
b=`echo "$line"|cut -d ',' -f 2`
c=`echo "$line"|cut -d ',' -f 3`
d=`echo "$line"|cut -d ',' -f 4`
e=`echo "$line"|cut -d ',' -f 5`
f=`echo "$line"|cut -d ',' -f 6`
g=`echo "$line"|cut -d ',' -f 7`
h=`echo "$line"|cut -d ',' -f 8`
k=`echo "$h@mail.ad.ge.com"`
i=`echo "$line"|cut -d ',' -f 9`
t="KK"

echo $f>/data/informatica/Services_2/CSASERVICES04/TgtFiles/Echo_special_character.txt
pop=`sed 's/\^/\,/g' /data/informatica/Services_2/CSASERVICES04/TgtFiles/Echo_special_character.txt`
echo $pop>/data/informatica/Services_2/CSASERVICES04/TgtFiles/Echo_special_character.txt
pop=`sed 's/||/\$/g' /data/informatica/Services_2/CSASERVICES04/TgtFiles/Echo_special_character.txt`

if [ $z = $g -o $z = $t ]
then
Spt=$Spt"<tr>
<td> "$a" </td>
<td> "$c" </td>
<td> "$d" </td>
<td> "$e" </td>
<td> "$pop" </td>
<td> "$i" </td>
</tr>"
fi

if [ $z != $g -a $z != $t -o $a = $defaultengine ]
then
cc=$(printf '%s\n' "$cc" | awk -v RS='[,[:space:]]+' '!a[$0]++{printf "%s%s", $0, RT}')
cc="${cc%,*}"
cc=`echo $cc",307009431@mail.ad.ge.com,210026614@mail.ad.ge.com,502301326@mail.ad.ge.com,210077716@mail.ad.ge .com"`

echo "
<html>
<head>
<title>any title</title>
</head>
<body>
Hi, 
For your action below are the details
<table border='2'>
<tr>
<td> ESN </td>
<td> Module </td>
<td> Keyword </td>
<td> Bucket </td>
<td> Comment </td>
<td> Priority </td>
</tr>
"$Spt"

</table>
 
 
WIP Link:<A Href='sc.ge.com/*WIPanalytics'>WIP-ANALYTICS</A> 

Regards 
MCRB Shop Team
</body>
</html>
" | mailx -s "$(echo -e "Engine Escalated\nContent-Type: text/html")" -c $cc $z

Spt="<tr>
<td> "$a" </td>
<td> "$c" </td>
<td> "$d" </td>
<td> "$e" </td>
<td> "$pop" </td>
<td> "$i" </td>
</tr>"

fi
z=$g
if [ $count = 0 ]
then
cc=$k
else
cc=$cc","$k
fi
count=$count+1

done </data/informatica/Services_2/CSASERVICES04/TgtFiles/escalate_data1.out

I am struck at this to understand:

cc=$(printf '%s\n' "$cc" | awk -v RS='[,[:space:]]+' '!a[$0]++{printf "%s%s", $0, RT}')

pan64 · 07-06-2017, 07:08 AM

ok. again, please use code tags (no quote) around your script.
printf is a bash builtin, and you can check

Code:

printf '%s\n' "$cc"

is just prints the content of the variable cc (together with a \n at the end).
| will send that text to awk.
the awk command consists of 2 parts:

Code:

-v RS='[,[:space:]]+'

sets the variable RS. RS is the [input] record separator, so this string will tell awk how to separate records (=originally those are the lines): a comma and a whitespace and may be repeated several times.
the next part is the script itself:

Code:

!a[$0]++{printf "%s%s", $0, RT}

here RT is the record terminator, see man page of awk about that.
a[$0] will store all the input lines (which are the email addresses - separated by comma), and ++ counts their occurrences. !a[$0]++ is a check and will be true if a[$0] is 0 or undef, so when a given email comes first (other instances will increment a[$0]. { print } will occur only if the check was true.
So this awk will remove duplicated email addresses - and the final result will be stored in cc again.