AnsweredAssumed Answered

Remove commas from qualified text fields using regex

Question asked by 23217526 on Jun 16, 2016
Latest reply on Jun 17, 2016 by 23217526



I'm trying to use a "Search/Replace" Data Process step to remove the commas inside qualified text fields such as "M,ATT"


I used a regex ("[^",]+),([^"]*") to find the field, and if I use replace with \1\2 in Notepad++ it works and the result is "MATT", but when I do the same thing in a process, it deletes the complete string, so a before and after would look like:


"SID0590092","M,ATTT","","S00008872181","D00010722270","00751","67424841","4","0000","AVAILABLE","67424841","", 0.00,"","00751","M,ATTT","00000","A1603908",990,990,"",23,


"SID0590092",,"","S00008872181","D00010722270","00751","67424841","4","0000","AVAILABLE","67424841","", 0.00,"","00751",,"00000","A1603908",990,990,"",23,


But I want it to do this:


"SID0590092","MATTT","","S00008872181","D00010722270","00751","67424841","4","0000","AVAILABLE","67424841","", 0.00,"","00751","MATTT","00000","A1603908",990,990,"",23,


Is there a different way to do this?


Thanks in advance,

Ricardo Diaz.