Splitting a String at the Comma into FirstName and LastName

[HLeyes]

In tMap, is there a way to test a string to see if it has a comma, and if it does, split it at the comma into FirstName and LastName?

Thanks in advance,

HLeyes

[TRF]

row1.fullname.contains(",") ? row1.fullname.replaceAll(",.*$", "") : row1.fullname   --> to populate out.Lastname
row1.fullname.contains(",") ? row1.fullname.replaceAll("^.*,", "") : ""   --> to populate out.Firstname
Check the syntax before to go

Regards,
TRF

[HLeyes]

Thanks, TRF.  I'll test it out!

HLeyes