[SOLVED] Ignoring commas within double quotes

[lomcevak]

I'm trying to write a bash script that has to extract values from a csv file. Problem is there are lines like this:

a,b,c,"dd,dd,dd",e,f,g

I'm using awk to extract the values but when I try it extract value 4 with awk I get:

"dd

instead of:

"dd,dd,dd"

Does anyone know how to get awk to ignore commas within double quotes?

[barriehie]

I'm trying to write a bash script that has to extract values from a csv file. Problem is there are lines like this:

a,b,c,"dd,dd,dd",e,f,g

I'm using awk to extract the values but when I try it extract value 4 with awk I get:

"dd

instead of:

"dd,dd,dd"

Does anyone know how to get awk to ignore commas within double quotes?

Try this:
file: testfile
a,b,c,"dd,dd,dd",e,f,g
h,i,j,k,l,"mm,mm,mm",n

 cat ./testfile | gawk '{ if($0~/^.*".*".*$/) { gsub(/"/,"",$0); print $0 } else { print $0 } }'

Edit: I just reread your post after posting, do you want to just nuke the quotes or make it look like dddddd or dd,dd,dd???

Output:

a,b,c,dd,dd,dd,e,f,g
h,i,j,k,l,mm,mm,mm,n

[lomcevak]

Thanks for the reply. Right now if I say:

awk '{print $4}'

The output is "dd

I want the output to be "dd,dd,dd"

Ideally I would like the double quotes removed but I can do that later with sed if I have to.

My knowledge of awk if very limited.

[barriehie]

Thanks for the reply. Right now if I say:

awk '{print $4}'

The output is "dd

I want the output to be "dd,dd,dd"

Ideally I would like the double quotes removed but I can do that later with sed if I have to.

My knowledge of awk if very limited.

Makes 2 of us! So you want each field on its own line?
Like this:

a
b
c
"dd,dd,dd"
e
f
g

[Franklin52]

You can do something like this:

awk -F\" '{for(i=1;i<=NF;i+=2) {gsub(",", ";", $i)}}1' OFS= file.csv |
awk -F\; '{ print $1;print $2;print $3;print $4;print $5}'

[lomcevak]

Thanks Franklin52, that works.