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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Krish2459_58
Creator II
Creator II

extract text from osuser()

Hi - I need to extarct the user name from osuser() as per below output.

 

OSUser( )

UserDirectory=; UserId=abcdefgh@gmail.com

 

required output in upper case: ABCDEFGH

Labels (2)
1 Solution

Accepted Solutions
robert_mika
Master III
Master III

upper(SubField(SubField(OSUser(), ';', 2), '=', 2))

View solution in original post

1 Reply
robert_mika
Master III
Master III

upper(SubField(SubField(OSUser(), ';', 2), '=', 2))