Problem with awk

Shell Programming and Scripting
1

I have a file from where i need to extrat 2nd column:
sample input is :
"THHSBC001900000006 CSG00100000 OTHOTH THB AA0100101100", "THHSBC001", "1-01-01", "THB"
"THHSBC001900273009 AOC00100000 OTHOTH THB AA0100106260", "THHSBC001", "1-01-01", "THB"
"THHSBC001902501940 SDY00100000 OTHOTH USD AA0100102000", "THHSBC001", "1-01-01", "USD"

the record in bold letter is just one record and so the other .
Now, columns are seperated by commas and
"THHSBC001900000006 CSG00100000 OTHOTH THB AA0100101100" is 1 st column
THHSBC001 is 2nd column
but when i try to extract 2nd column i.e. THHSBC001 using follwing code,

while read Record1
do
Acct_Num=`echo $Record1 | awk '{print $2 }'`
echo "Acct_Num is $Acct_Num"
done < $REGSeqFileName

i am getting CSG00100000 thing from 1st column , is there any way so that i can get desired ouput.

Thanks

2

See my reply in your other thread, and please do not start a second thread for the same question: Problem with Substring