How to remove a character which is enclosed in Double quotes

mohan_tuty · #1 (**permalink**) 05-14-2008

I want to remove the comma which is present within the double quoted string. All other commas which is present outside double quotes should be present.

Input : a,b,"cc,dd,ee",f,ii,"jj,kk",mmm

output : a,b,"ccddee",f,ii,"jjkk",mmm

jim mcnamara · #2 (**permalink**) 05-14-2008

one long-winded way with awk:

Code:

echo 'a,b,"cc,dd,ee",f,ii,"jj,kk",mmm' | \
  awk -v sep='"' '{
         for(i=1;i<=length($0); i++)
         {
            ch=substr($0,i,1)
            if(ch==sep) {inside=!inside}
            if (inside && ch==",") {continue}
            printf("%s",ch)
         }
         printf("\n")
       }'

Franklin52 · #3 (**permalink**) 05-14-2008

Another one:

Code:

 awk 'BEGIN{FS="\"";OFS=""}{gsub(",","",$2);gsub(",","",$4)}1' file

Regards

freelong · #4 (**permalink**) 06-16-2008

Quote:

Originally Posted by mohan_tuty

I want to remove the comma which is present within the double quoted string. All other commas which is present outside double quotes should be present.

Input : a,b,"cc,dd,ee",f,ii,"jj,kk",mmm

output : a,b,"ccddee",f,ii,"jjkk",mmm

OK, no matter how many double quotes you have, you always can use the following awk program:

Code:

BEGIN{
        FS="\""
        OFS="\""
        }
        {for(i=1;i<=NF;i++)
                if(i%2 == 0)
                        gsub(/,/, "", $i)
        print
        }

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Remove double quotes	deepakwins	UNIX for Dummies Questions & Answers	3	05-30-2008 11:53 AM
Double quotes or single quotes when using ssh?	password636	Shell Programming and Scripting	3	05-29-2008 08:52 PM
put double quotes for a column	sumeet	Shell Programming and Scripting	3	05-09-2007 07:20 PM
How do I insert double quotes	dsean	Shell Programming and Scripting	3	05-26-2006 01:28 PM
Double Quotes within a variable	burton_1080	Shell Programming and Scripting	4	12-01-2005 01:44 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by