Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ehasnawi98
Contributor II
Contributor II

How to take first and last element when we split string

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

In Qlik, We can write like

SubField(FullName, ' ', 1) as FirstName

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

 

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Anil_Babu_Samineni

In Qlik, We can write like

SubField(FullName, ' ', 1) as FirstName

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

 

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ehasnawi98
Contributor II
Contributor II
Author

Thankyou ! it works