mjhjmtu

I have document contain very long strings represent decoded information, i want to remove , commas from the last portion of the string. For example this is one of the long strings:

 Insert into PE_ATRT_S(ID_ANA_TX,FQ_WQ_ASDF,ID_PRTY,NM_ATHY_TX,SC_RND,QU_DGT_RND) values (99990987868959,null,68,'T59 - %,Dsc,Itm-2 tax 1 Juris',4,5);

I want to remove comma from the last portion of it so let me zoom in to show you how it look like:

(99990987868959,null,68,'T59 - %,Dsc,Itm-2 tax 1 Juris',4,5);

so the final result look like this:

Insert into PE_ATRT_S(ID_ANA_TX,FQ_WQ_ASDF,ID_PRTY,NM_ATHY_TX,SC_RND,QU_DGT_RND) values (99990987868959,null,68,'T59 - % Dsc Itm-2 tax 1 Juris',4,5);

please notice the last portion of the long string, no comma in part of it let's zoom in to see it better:

(99990987868959,null,68,'T59 - % Dsc Itm-2 tax 1 Juris',4,5);

I spent hours trying to find a way to do it but I failed, would you please help me to fix these strings, thanks!

awk -F' -vOFS=' 'gsub(","," ",$2); print'

Alternative solution with gnu sed:

sed -r 's/(x27.*),(.*x27)/1 2/g' file

x27 : ascii code of single quote '

Perl showcase:

perl -pe "1 while s/'.*K,(?=.*')/ /" input.txt

Output:

Insert into PE_ATRT_S(ID_ANA_TX,FQ_WQ_ASDF,ID_PRTY,NM_ATHY_TX,SC_RND,QU_DGT_RND) values (99990987868959,null,68,'T59 - % Dsc Itm-2 tax 1 Juris',4,5);

Zoomed output:

(99990987868959,null,68,'T59 - % Dsc Itm-2 tax 1 Juris',4,5);