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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars TRF
Twelve Stars

Re: CSV column custom parser

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


TRF
3 REPLIES
Twelve Stars TRF
Twelve 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