topic Re: Removing \, (backslash comma) in incoming CSV file in Talend Studio

Removing \, (backslash comma) in incoming CSV file

SCook — Fri, 08 Mar 2024 23:41:20 GMT

I am receiving a CSV file that has an escaped comma. I need to remove the \, from the file because otherwise the comma causes an offset and adds extra columns. I have tried using CSV options and various functions in tMap but haven't been able to accomplish this. I am using Talend Studio v8.

For example, I need to remove the \, after Drug so that it is just Drug Fentanyl or Drug-Fentanyl (if I replace space with dash). The data is not encased in double quotes and looks exactly like below. It comes in from the original source as 'Drug, Fentanyl' and a 3rd party is escaping the comma.

Item1234,Drug\, Fentanyl .05mg/ml

Re: Removing \, (backslash comma) in incoming CSV file

Shicong_Hong — Mon, 11 Mar 2024 02:34:02 GMT

You can read the entire file as a string ,and replace "\," with "", then generate a new csv file or extract fields using tExtractDelimitedFields. eg:

tFileInputRaw--main--tJavaRow--tFileOutputRaw

on tJavaRow:

output_row.content = input_row.content.toString().replaceAll("\\\\,","");

Regards

Shicong