Substring Issue in talend

[JG6]

Hi Team,

I need to implement this talend .. this is currently written in abinitio.Please help urgently

(is_defined(lookup("Lookup_File", ((decimal("\307"))re_index(id, "[a-zA-Z]+") - 1),string_substring(id, (decimal("\307"))re_index(id, "[a-zA-Z]+") , string_length(id))).name))

[JG6]

someone please help urgently ​

[JG6 · Accepted solution]

can somebody help me on this urgently..i know i have to use tma​p for lookup ,but i m not sure how to use that re_index code in talend

[JG6]

please help ​