Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 )