Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
qbi_soren
New Contributor II

how to extract part of a text string

Hi Community

I need to extract that part of a text string, that is placed left from the '@'

(username@domain.code) - can that be done and how?

//Soren

2 Replies
aveeeeeee7en
Valued Contributor III

Re: how to extract part of a text string

hi

use this:

subfield(yourfieldname,'@',1) as username

create this field in the back end script. After doing reload use this script In the front end.

Regards

Aviral Nag

joshabbott
Contributor III

Re: how to extract part of a text string

=left([Field with Email], index([Field with Email], '@') - 1)