Describe The Process To Separate The Given Names Into First_name And Middle_names Columns In Talend.

 We use an expression called the ternary operation to separate the given names. A simple tMap expression is just a single line Java Code. 

• For the first name extraction, we use this expression.

 

StringHandling.INDEX(row1.GivenNames," ") > 0 ? StringHandling.LEFT(row1.GivenNames,StringHandling.

INDEX(row1.GivenNames," ")) : row1.GivenNames

 

• For middle name extraction, we use

 

StringHandling.INDEX(row1.GivenNames," ") > 0 ? StringHandling.RIGHT(row1.GivenNames,StringHandling.

LEN(row1.GivenNames)-StringHandling.INDEX(row1.GivenNames," ")–1) : ""