
Announcements
The below is a record from CSV. When I am doing split with comma, I am not getting desired output as the the data in description field has comma i.e \"CRQ0000001 pre-firmware update 12-SEP, created by Citrix\".
Is there a way, I can remove comma wherever comma is there within \"........\"
[
"srv1,S217124,CustomerABC,firmware update,\"CRQ0000001 pre-firmware update 12-SEP, created by Citrix\",22.66,2022-09-12@14:16:36,8,\"Status is open, more than 1\",saumendra pramanik\r",
""
]
Thanks,
Saumendra
Hi @saumenniit
@PrasadAthalye has a nice solution approach for this:
You could first split on the " character or "\ characters. Per item you could replace the , character and append the results to a new array. After that you should be able to apply your normal split.