Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (2)
1 Reply
vapukov
Master II
Master II

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