You may want to try this with a tJavaRow.....but to be honest, the code I am giving you can be wrapped up in to a Talend Routine and used in a tMap.
Lets assume your data is arriving at the your tJavaRow in a column called "categories" and is leaving in two columns ("out1" and "out2"). You need to create your output schema in the tJavaRow first. Then use the code below to split out your data.....
//Save your input data to a Sting variable
String cats = input_row.categories;
//Check if there is data as we can do nothing with null
if(cats!=null){
//Use the String split method to split your String by >
String[] catArray = cats.split(">");
//Check that catArray has more than 0 elements
if(catArray.length>0){
output_row.out1 = catArray[0].trim();
output_row.out2 = catArray[catArray.length-1].trim();
}else{
output_row.out1 = "";
output_row.out2 = "";
}
}else{
output_row.out1 = "";
output_row.out2 = "";
}
This is a very basic way of doing it, but should let you extrapolate from it or just use it as it is.
Hello & Thanks to both of you for your precious time;
As I tried to explain the easiest way, I prefer to stay on Tmap considering my job; more composants would blow my mind. I tried your process @vboppudi but I forgot that i have some field in Category that are empty. So I get an error :
Exception in component tMap_1 (TestKooples) java.lang.NullPointerException
