topic Re: csv options for tfileinputdelimited in Talend Studio

csv options for tfileinputdelimited

RA6 — Sat, 16 Nov 2024 07:19:38 GMT

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

Re: csv options for tfileinputdelimited

Anonymous — Sat, 10 Nov 2018 15:38:39 GMT

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

Re: csv options for tfileinputdelimited

RA6 — Mon, 12 Nov 2018 13:04:09 GMT

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

Re: csv options for tfileinputdelimited

Anonymous — Mon, 12 Nov 2018 13:22:00 GMT

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

Re: csv options for tfileinputdelimited

cterenzi — Mon, 12 Nov 2018 18:20:35 GMT

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

Re: csv options for tfileinputdelimited

RA6 — Tue, 13 Nov 2018 09:46:58 GMT

Hello @nthampi,

By mistake, i have mark your reply as solution.

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

Re: csv options for tfileinputdelimited

manodwhb — Tue, 13 Nov 2018 11:55:31 GMT

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