Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to map the OSUser function value to the actual user name for the user and have not been successful. I have stored the usernames and user full names in a table and I am using the following set analysis:
=Max({<USER_NAME={'$(=Upper(SubField(OSuser(),'\',2)))'}>} USER_FULL_NAME)
Any help would be great
Max returns the maximum number, your should use maxstring.
=Maxstring({<USER_NAME={'$(=Upper(SubField(OSuser(),'\',2)))'}>} USER_FULL_NAME)
Or, if every UserID only occurs once in your tble, use Only() like in:
=Only({<USER_NAME={'$(=Upper(SubField(OSuser(),'\',2)))'}>} USER_FULL_NAME)