Instring / Substring function in tmap

Anonymous — Tue, 07 Mar 2017 05:59:53 GMT

Hello,
I want to take substring from one column and map that to the destination table via tamp. I find LEFT and RIGHT functions in string Handling but not the instring. Can anyone clarify?
Example: I want to extract the 6 char from the string starting position 4.
Input column value: 1238AVC957AWC12022007
Output Column value should take AVC957

Re: Instring / Substring function in tmap

vapukov — Tue, 07 Mar 2017 07:20:17 GMT

RIGHT(LEFT(string,10),6)
as alternative - write Your own routine for use Java Substring - StringUtils
some good people do this already on TalendExchange

topic Re: Instring / Substring function in tmap in Talend Studio

Instring / Substring function in tmap

Re: Instring / Substring function in tmap