I have a bunch of Gzip-compressed CSV files which are separated by comma delimiters as show below:
"000001","SessionID_11111",,,,"[{""c1"":""v1"",""c2"":""v2"",""c3"":""v3""}]",,,,"{""products"":[{""c1"":""v1"",""c2"":""v2"",""c3"":""v3""}]}","{}",,1,2,,,
What I want to do is convert comma delimiter to TAB, while preserving those within JSON/Array documents like this:
"000001"t"SessionID_11111"tttt"[{""c1"":""v1"",""c2"":""v2"",""c3"":""v3""}]"tttt"{""products"":[{""c1"":""v1"",""c2"":""v2"",""c3"":""v3""}]}"t"{}"tt1t2ttt
Those JSON/Array fields are making weird and unwanted output.
How can I get the good output?
3