Answers
P
Aryan Sharma

Posted on 5th March 2024

 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) : ""

 

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos