Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. 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 )