Remove comma between characters

[micheledenardi]

Dear all,

i have some records like these:

abc,123,b3,"this is a comma,",abc,"this , is another comma",bye bye
abc,"12,3",b3,"this is a comma",abc,"this , is another, comma",bye bye

 and i would like to remove (or replace with another character) all commas  within double quotes (highlighted in yellow), and keep all other commas (outsite double quotes).

How to do this?

thanks

[Lauri]

Try the TextBetween function.

[marcus_sommer · Accepted solution]

This should be manageable with the msq-feature like:

LOAD * FROM PoorCommaSeapratedData.txt (txt, codepage is 1252, no labels, delimiter is ',', msq);

- Marcus