topic First Name & Last Name in QlikView

First Name & Last Name

rammarthi — Wed, 26 Apr 2017 14:18:14 GMT

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

Re: First Name & Last Name

swuehl — Wed, 26 Apr 2017 14:33:13 GMT

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);