Any "sed" experts out there? Help required!

[PlumpMonkey]

I was wondering if there are any "sed" experts out there. My skills are weak and Im having trouble creating an expression to do what I want.

I have a comma delimited line such as;

 a,b,c,d,"e,f,g,h",i,j,k,l,"m,n,o,p,q",s,t

I want to remove anything in-between and including the quote marks. Eg the result would be

 a,b,c,d,,i,j,k,l,,s,t

The double ,, is ideal for me.

I have the following sed command

 sed 's/".*"//g'

but this removes everything between the first " and last " giving me

  a,b,c,d,,s,t

Anybody got any ideas how I can achieve what Im after?

Cheers!

 

[droyden]

Must be sed?

 

[droyden]

I have a comma delimited line such as;

 a,b,c,d,"e,f,g,h",i,j,k,l,"m,n,o,p,q",s,t

I want to remove anything in-between and including the quote marks. Eg the result would be

 a,b,c,d,,i,j,k,l,,s,t

$ echo 'a,b,c,d,"e,f,g,h",i,j,k,l,"m,n,o,p,q",s,t' | perl -p -e 's/".+?"//g;'
a,b,c,d,,i,j,k,l,,s,t

Perl :/

 

[PlumpMonkey]

That will do the job lovely thanks! I forgot about perl. Sed doesnt like the non-gready ? and it was throwing me...

Cheers very much. Youve made my day much easier!

 

[droyden]

No problem - yeah, apparently sed is greedy!