Comparing OSUSER and user_name

[#1]

Hi All,

OSUSER is happiest\keerthi and i have a field called user_name.

User_name has many names such as keerthi, Anil without the domain.

When i click on a button, it should compare OSUSER with the user_name. If user_name matches  then particular user_name should be selected.

Please help me with this. i don't know how to check between OSUSER and user_name because of the domain.

Please reply ASAP.

Thanks & Redards,

Keerthi

[maxgro · Accepted solution]

to extract the user from osuser() you can try this

Right(OSUser(), len(OSUser()) - index(OSUser(), '\'))

in a button

select in field

field =

user

search string =

=Right(OSUser(), len(OSUser()) - index(OSUser(), '\'))

[swuehl]

You can extract the user name only using

=subfield(OSUser(),'\',2)

and you try using this expression as search string in a select in field button action (for selection in field user_name).

[#4]

Thanks Massimo

[#5]

Thanks Swuehl