topic Re: How to truncate a string in a tjavarow in Talend Studio

How to truncate a string in a tjavarow

JMartin1 — Fri, 15 Nov 2024 22:30:34 GMT

Hello! I have a problem when inserting a dynamic file into an oracle table, there are fields in the file of length greater than 4000, I am trying to shorten the string to the length that allows me to insert in the table(Drop create)

Re: How to truncate a string in a tjavarow

Anonymous — Tue, 04 Oct 2022 10:40:07 GMT

You can use the standard Java String methods to achieve this or write your own routine (essentially a Java class) to do this if you need to apply complicated rules to decide upon how to truncate the Strings.

Re: How to truncate a string in a tjavarow

JMartin1 — Thu, 06 Oct 2022 14:30:45 GMT

Hi!, samething like this:

Dynamic dyn = row1.InputRow;

for(int i = 0; i < dyn.getColumnCount(); i++){

DynamicMetadata meta = dyn.getColumnMetadata(i);

// System.out.println(meta.getName()+ "; " + StringHandling.SUBSTR(dyn.getColumnValue(i).toString(), 1, 10));

dyn.setColumnValue(i, StringHandling.SUBSTR(dyn.getColumnValue(i).toString(), 1, 4000));

meta.setLength(4000);

}

row2.InputRow = dyn;

Re: How to truncate a string in a tjavarow

Anonymous — Thu, 06 Oct 2022 15:10:34 GMT

A while ago I wrote a blog on doing something similar to this. I have just hunted it out as it is no longer available on our blog page here. You can see it here....

https://web.archive.org/web/20200919070520/https://www.talend.com/blog/2019/11/11/migrate-data-between-databases-one-job-using-dynamic-schema/

The code should be a good pointer about how to get access to the columns in a dynamic schema.