CSV column custom parser

Highlighted
Four Stars

CSV column custom parser

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.

 


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

Re: CSV column custom parser

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


TRF

All Replies
Fifteen Stars TRF
Fifteen Stars

Re: CSV column custom parser

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


TRF
Four Stars

Re: CSV column custom parser

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

Four Stars

Re: CSV column custom parser

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

 

Regards,

Nagaraju Adapala 

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.