Hello,
I'm trying the solve the following problem.
I have a file which I intend to use as a csv called master.csv
The columns are separated by commas.
I want to change the text on a specific row in either column 3,4,5 or 6 from xxx to yyy depending upon if column 1 matches a specified pattern.
The column to change (i.e. 3/4/5/6) is dependent upon the value of the variable in a nested loop
The awk statement is located within a nested loop of a parent loop. It will use the variable value from the parent loop for column 1 and the variable value from the nested loop for column 3/4/5/6.
Below is an example of the code:

 
#Update the CSV file
cat $USERDUMP |awk -F , '{print $1}' |sort -u |\
 while read username
 do
     for LOOP_LIST in $SERVER_LIST
     do
     grep $username $DATADUMP.$LOOP_LIST >> /dev/null 2>&1
     RET_CODE=$?
     if [[ $RET_CODE -eq 0  ]]
     then
          echo    "User $username exists on $LOOP_LIST"
          awk -F "," -v user=$username -v server=$LOOP_LIST '/$user/ {gsub(/$server/,"Yes"); print}' master.csv
     else
          echo "User $username does not have account on $LOOP_LIST"
     fi
     done
 done

$ awk -F "," '/userA/ {gsub(/ServerA/,"Yes"); print }' master.csv
userA,comment,Yes,ServerB,ServerC,ServerD

sed -i  "/$user/ s/$server/Yes/" master.csv_bkp

Please post:
1) sample of $USERDUMP ,
2) contents of $SERVER_LIST ,
3) sample of $DATADUMP.$LOOP_LIST (at least 1 file), and
4) sample output.

This will be very much helpful to people to provide an efficient solution to your problem.

I used the sed code instead of the awk command and this has given me exactly what I wanted!
Thanks for the help guys