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