Discussion board where members can get started with QlikView.
I need to extract that part of a text string, that is placed left from the '@'
(firstname.lastname@example.org) - can that be done and how?
subfield(yourfieldname,'@',1) as username
create this field in the back end script. After doing reload use this script In the front end.
=left([Field with Email], index([Field with Email], '@') - 1)