topic Re: CSV column custom parser in Talend Studio

CSV column custom parser

Anonymous — Sat, 16 Nov 2024 09:44:36 GMT

I would like to import numeric columns from CSV file in custom format. One column has "#N/A" when value is not available, while other contains percentages and have "%" at the end.

Re: CSV column custom parser

TRF — Tue, 23 May 2017 10:55:20 GMT

So datatype in the CSV schema must be string and you have to convert by yourself.

Re: CSV column custom parser

Anonymous — Wed, 24 May 2017 06:54:00 GMT

I was afraid that somebody would say that
Thank you! I did it with mapper and some custom routines.

Re: CSV column custom parser

Anonymous — Wed, 24 May 2017 09:40:20 GMT

Can you please post the customization mapping so it will be helpful for others.

Regards,

Nagaraju Adapala