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(":");
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.