How to read a delimited file whose delimiter is a a comma and there is a column with value("60,00")

[Ray0801]

Data example

Id,Name,Salary,Day

12,ABC,"16,00",Thursday

THE value "16,00" is getting split into "16 &00" how to avoid this.

I am using Talend Open Studio For D1

[gjeremy1617088143]

Hi, if you can identify the coma, here : a double quote some digits a coma followed by some digits and an other double quote(of course this patern have to be unique).

You read your file with tfileinputraw then in a tjavarow : (your string).replaceAll("(?<=\"(\\d{1,10})),(?=\\d{1,10}\")","the caracter you want instead : a dot for example")

then you write it in a tfileoutputraw, finally you can read it in fileinputdelimited.

Send me Love and Kudos

[gjeremy1617088143 · Accepted solution]

or if you want to keep this coma you negate all the regex lookbehind and lookahead : (your string).replaceAll("(?<!\"(\\d{1,10})),(?!\\d{1,10}\")","the caracter you want instead : § for example")

and after you can read your file with § as field separator

[Ray0801]

@guenneguez jeremy​ Thank You