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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Separate String into two columns

Hello, 

I am new at Talend. 

 

I want to split Name column to two columns. The Name column contains string like this: 

John Adam (It)

Jems Bill (HR)

I want to separate the job name between the parenthesis in a separate column. How can I do this with tMap. 

Labels (2)
1 Reply
TRF
Champion II
Champion II

Use string.split with ( as the delimiter to form 2 separated strings then string.replace to remove extra )