Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mwscott1
Creator
Creator

How to split and read only part of date

I am pulling from an excel file and for the Identity column I only need the name out of the data for each record

Example:

Server/Accounts/Users/John Doe\1645587952551528449

All I need is the John Doe.  All entries are the same except the name and quid at the end are different for each user.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

subfield(subfield(MyFieldHere,'/',4),'\',1)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

subfield(subfield(MyFieldHere,'/',4),'\',1)


talk is cheap, supply exceeds demand
its_anandrjs
Champion III
Champion III

Hi,

If name position is fixed then use =mid(ColA, 23, len(ColA)  -  42)

Thanks & Regards