input > 20000000,"xxxxxxxxxxxxx,xxxxxxxxxxx", 192.168.3.2
Ideal result >20000000,"xxxxxxxxxxxxxxxxxxxxxxxx", 192.168.3.2

How do I get rid of the comma between the quotes?
There are also lines without the comma between the quotes
Thanks in advance

And your attempts so far ?. Why do you think they failed ?.

I did try using grep to take out the lines with comma in quotes then replacing them, afterward combining the 2 files, however if i did that it would no longer be in order.

sed would my tool of choice - but you need to be able to precisely define the string in regex, and use back-references.
For example:
- only one set of double-quotes per line ?
- any possibility of un-matched double-quotes ?
- any possibility of multiple commas within double-quotes ?
...

Nothing is ever as easy as it first looks. Especially when we don't have all the specifications and/or data.

E.g
Exchange subsidary,Passed,00021423SNG,R-JAM-05-03,US (First Exchange),20000000,"JUDICIARY, STATE COURTS (STATE COURTS)",112.78.212.12/30,00052312SNG,R-JPODIU-023-07,US (First Exchange) ,20000000,"JUDICIARY, STATE COURTS (STATE COURTS)",112.78.224.213/30


There are also line like this (without comma between in the " ")
Exchange subsidary,Passed,00021423SNG,R-JAM-05-03,US (First Exchange),20000000,"xxxxxxxxxxxxx",112.78.212.12/30,00052312SNG,R-JPODIU-023-07,US (First Exchange) ,20000000,"xxxxxxxxxxxxxx",112.78.224.213/30

I need to remove the comma inside ,"JUDICIARY, STATE COURTS (STATE COURTS)" (both)
Thanks in advance

So now that you have shown actual data your problem is compounded as now you have many combinations and possibilities, so many in fact that it may not be possible and you may have to simply hand alter
the file.

I would say that with a good editor like vim you should be able to quickly find and change any such commas.

Ok thanks for the advice

This should work - caveats apply, but it should remove (totally) the first comma within each set of double-quotes. If some remain, just run it again. Keep a backup of the input file before you start.

try this sed command below, as syg00 suggests backup the input file before doing anything.

isn't this some sort of .json file?
wouldn't it be easier to use tools designed to deal with json data?

(not a rhethorical question; i am currently facing a similar problem with some database text file, i think it's json)

what about using " as line separator and replace , only in every second line?

With " as field separator, and replace in every second field

1 members found this post helpful.