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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
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))