How to take first and last element when we split string

[ehasnawi98]

Hello , im new to this qliksense , i want to ask is it possible to take the first and last element from string ?

if C# we can do like string.Split('delimiter').First() / string.Split('delimiter').Last()

how about in qliksense?

example data:

Full name

1. Andy Robertson Jason                         Expected Result : First : Andy, Last : Jason

2. Bernard Andy Robertson Jason       Expected Result : First : Bernard , Last : Jason

[Anil_Babu_Samineni · Accepted solution]

In Qlik, We can write like

SubField(FullName, ' ', 1) as FirstName

SubField(FullName, ' ', -1) as LastName

[ehasnawi98]

Thankyou ! it works