First Name & Last Name

[rammarthi]

Hi,

I have a list of first names and last names. For some first names are extended to middle names in the same cell. Such middle names start with Capital Letter. And as an anomaly in data set a set of names like "Akhil esh" where the later half is actually the part of first half and not a separate middle name. How to identify such names and remove the space in between. Can any one help me on this.

Here is the data in quest.

First Name	Last Name
Raghu Nath	Kalya
Kal yan	Ram
Akhil esh	Yadav
Uma Rama	Linga
Pras anth	Reddy

Here is the anticipated result:

First Name	Middle Name	Last Name
Raghu	Nath	Kalya
Kalyan		Ram
Akhilesh		Yadav
Uma	Rama	Linga
Prasanth		Reddy

[swuehl]

Maybe like

LOAD

  if([First Name]=Capitalize([First Name]),Subfield([First Name],' ',1), replace([First Name],' ','')  ) as [First Name],

  if([First Name]=Capitalize([First Name]), Subfield([First Name],' ',2),'') as [Middle Name],

  [Last Name];

LOAD [First Name],

     [Last Name]

FROM

[https://community.qlik.com/thread/258441]

(html, codepage is 1252, embedded labels, table is @1);