csv options for tfileinputdelimited

[RA6]

Hello folks,

I have the below Input CSV with quoted values and field separator ";"

"400";"BQE";"2011-01-31";2530;10;"";"41100;000"
"404";"OD";"2011-01-13";2251;2;"";"41;100000"
"504";"VTE";"2011-02-28";66434;1;"","4110000;0"

I want to achieve this result in CSV without the quotes [note that column G still have the quotes in values]:

 

Is there a way i can use the CSV options below?

When do we use "Escape char" and "Text encosure"?

Thank you for your help.

Best regards,

asadasing

[Anonymous]

Hi,

    You will be able to do it using CSV options. Please see the job and output details in below screenshots. Do not worry about the date column pattern since you can change them with Talend date format functions.

Job Flow

Output from tlogrow

Regarding your second query about the difference between escape character and text enclosure, there is already an article available and below link will help you to resolve your doubts.

https://stackoverflow.com/questions/43512095/usage-of-escape-char-and-text-enclosure

 If my reply has helped to resolve your queries, could you please mark the topic as closed? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

[RA6]

Hello @nthampi,

Thank you for your reply.

I have tried to apply the mentioned solution but it did not work. Below the result i am encountering:

Please find attached my csv file.

Can you check if it works on your it on your side if it works please?

I need to get the same values but without the quotes.

Thanks.

Best regards,

Asadasing

Test_Order.csv

[Anonymous]

Hi,

    Could you please share the component basic and advanced screenshots for tfileinputdelimited and advise whether you are using Builtin or repository connection?

Warm Regards,

Nikhil Thampi

[cterenzi]

I typically set my Escape Char value to "\\" and my Text Enclosure to "\""

[RA6]

Hello @nthampi,

By mistake, i have mark your reply as solution.

It did not work. Please find attached screen shot of my job + components:

[manodwhb]

@asadasing,remove the part after ; in G column using tMap.