CSV column custom parser

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 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read