TRIM COLUMNS

One Star

TRIM COLUMNS

Hi ,

I need to trim the columns which has data length more than i defined in output table

I tried trimm all columns option in tfile input delimited and also

I used the below expression in tmap

StringHandling.TRIM(row2.State_Name)

But still its throwing this error -----ORA-12899: value too large for column

Any help pls.....
Community Manager

Re: TRIM COLUMNS

Hi
The method trim() is used to trim the leading and trailing whitespace. If you want to cut the string, use the method substring().
What's the data looks like? What's the data type in target table?
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARTNER 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

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog