Get string UserID from OSUser Qlik Load Script

[pschwegler003]

Hi Community,

I would like to get only e-mailadres from the OSUser(). 

Result of OSUser is as follows:
UserDirectory = IDAM; UserId=name.surname@xxx.com

I would like to story the next string in a variable: 
name.surname@xxx.com

Tried several things like:
LET vActiveUser_email = '=right(vActiveUser_OSuser,len(vActiveUser_OSuser)-findoneof(vActiveUser_OSuser,";")-8)';

Could anyone help plz?

Thanks, Pascal

[lorenzoconforti]

LET vActiveUser_email =right('$(vActiveUser_OSuser)',len('$(vActiveUser_OSuser)')-findoneof('$(vActiveUser_OSuser)',';')-8);

[pschwegler003]

Thank you for your reply. 

Unfortunately, the result of that is : ")".

Ideas?

[Mauritz_SA · Accepted solution]

Hi @pschwegler003 

You can also use

Spoiler

LET vActiveUser_email = SubField(OSUser(),'=',-1);

Hope this helps.

Regards,

Mauritz

[pschwegler003]

This works! Thanks a lot!

[qlikF]

Kurze Frage: warum -1?

[MarcoWedel]

weil es der erste Teilstring von hinten sein soll