Extracting Names

[Anonymous]

Hello all,

I am getting name value in a single column as "LastName,FirstName MiddleName".

I want to extract all three names separately and load into three different columns using TMap.

Different cases are

FULLNAMES	FirstName	MiddleName	LastName
last,first middle	first	middle	last
last1 last2,first middle	first	middle	last1 last2
last,first	first	NULL	last
singleword	singleword	NULL	NULL
last,first middle extra	first	middle extra	last

Please Help.

[Anonymous]

Solution will be
tFileInputDelimited --> tmap --> tlogrow

Within tmap you can create three extra port in output side for 1st name, middle name and last name using java's substring and indexOf method.

Accept solution if it works