One Star

tJavaRow: can't break a string into substrings and load them all

I'm actually working on a talend job. I need to load from an excel file to an oracle 11g database.
I can't figure out how to break a field of my excel entry file within talend and load the broken string into the database.
For example I've got a field like this:
toto:12;tata:1;titi:15
And I need to load into a table, for example grade:
| name | grade |
|--------|--------|
| toto |12 |
| titi |15 |
| tata |1 |
|-----------------|
Actually I used a tJavaRow:
for(String pair : input_row.details.split(";")) {
String[] kv = pair.split(":");

String line= kv;
String allele = kv;


System.out.println(input_row.classe);
System.out.println(name);
System.out.println(note);

output_row.classe = input_row.classe;
output_row.name = name;
output_row.note = note;
}
If I only print it in console it work fine (break all the string and display all the substrings)
But if I use output_row.variable, it work only for the fisrt substring.
1 REPLY
One Star

Re: tJavaRow: can't break a string into substrings and load them all

Hi
Here is a workaround.
Regards,
Pedro