how to handle , in data where separator also commas in awk script

Shell Programming and Scripting
1 
TEST_HEME,"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1",CELL

when I split by

FS=","

then

$0=TEST_HEME
$1="SubNetwork=ONRM_RootMoR
$2=SubNetwork=ARNC1"

but I need this will be single value

"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1"
2

In this case I would use Perl instead of awk:

% print 'TEST_HEME,"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1",CELL' | 
  perl -MText::ParseWords -nle'
    print for parse_line(",",0, $_);
  '
TEST_HEME
SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1
CELL
3

Thanks for the reply.
but I have to do it in awk script .
and i have only FS to set

FS=","
TEST_HEME,"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1",CELL

TEST_HEME,"SubNetwork=ONRM_RootMoR , SubNetwork=ARNC1",CELL

I need to set value of FS which split only string which out of " " if it is in " " so it should ignore

4

Why? What's wrong with Perl?

awk is not the right tool for parsing such a CSV data ...

5

Take a look here.