Column Spliting.

[MuraliPrasath]

Hi

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

[rahulpawarb]

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

[tresesco · Accepted solution]

Try like:

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

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

[#4]

try this

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

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