Hi there,
I am still quite new to Talend and trying to build my DS jobs on Talend. I was quite surprised to find that there is nothing in StringHandling for Substring. I wasted 1 hr used many left, right and change in many variables to make substring work. While searching forum I found a suggestion to replicate Substring by using this "rha.ACTES.substring(0, java.lang.Math.min(rha.ACTES.length(),8))"
Not sure what is rha and ACTES but it didnt work for me. Sorry I am not great in Java and yes its Java based project I am working on.
Again for IfThenElse I found "String?value:value" It worked for me. Not sure if there is real IfThenElse in Talend for non Java programmer.
Please advice.
Thanks
Hi Shong,
New development : When I removed the Oracle connection stage and hardcoded the connection string in OracleOutput it start working. I am completely lost. My understanding was one connection can be used for all Input and output Oracle stages.
Thanks for your help mate!
Regards
Amit
Hi All,
I am also facing the error for Substring
E.g
row3.RES_NUMBER.substring(0,6): it is giving me the error
if i use the below code :
row3.RES_NUMBER.substring(0, java.lang.Math.min(row3.RES_NUMBER.length(),6))
result : no error.
i don't know the reason
Please help me in understanding the logic behind this.
Thanks!
