Separate String into two columns

Anonymous — Sun, 12 Jan 2020 12:56:12 GMT

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.

Re: Separate String into two columns

TRF — Sun, 12 Jan 2020 20:58:30 GMT

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