Instring / Substring function in tmap

Five Stars

Instring / Substring function in tmap

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
Thirteen Stars

Re: Instring / Substring function in tmap

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