topic Re: Column Spliting. in QlikView

Column Spliting.

MuraliPrasath — Wed, 25 Nov 2020 16:16:04 GMT

I've a field shown below. I Need to split first-name and last-name out of Saff field.

Need Help !

Example:

First Name: Last Name:

Lucia Waldinger

Marion Schnerider

Markus Peischl

Martin Henle

Re: Column Spliting.

rahulpawarb — Fri, 03 Mar 2017 05:14:42 GMT

Hello Murali,

Trust that you are doing well!

If you have full name present under Name field then you can refer below given options:

SubField(StaffName,' ',1) AS FirstName,
SubField(StaffName,' ',2) AS LastName

However, if the data field is Staff as shown in the given screenshot then use below given fields:

//White spaces around the '|' symbol (Separator)
SubField(SubField('AAS_CS Central Europe | Lucia Waldinger', '|', 2), ' ', 2) AS FirstName,
SubField(SubField('AAS_CS Central Europe | Lucia Waldinger', '|', 2), ' ', 3) AS LastName

//No white spaces around the '|' symbol (separator)
SubField(SubField('AAS_CS Central Europe|Lucia Waldinger', '|', 2), ' ', 1) AS FirstName,
SubField(SubField('AAS_CS Central Europe|Lucia Waldinger', '|', 2), ' ', 2) AS LastName

P.S.: Use any of the option depending on the white space around '|' symbol.

Regards!

Rahul

Re: Column Spliting.

tresB — Fri, 03 Mar 2017 05:15:10 GMT

Try like:

SubField(SubField(Staff, '|' ,2), ' ',1) as FirstName,

SubField(SubField(Staff, '|' ,2), ' ',2) as LastName,

Re: Column Spliting.

Fri, 03 Mar 2017 05:16:05 GMT

try this

subfield(subfield(staff,'|',-1),' '),1) as firstname

subfield(subfield(staff,'|',-1),' '),2) as lastname