Forum Discussion

saivina2920's avatar
saivina2920
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

How to split specific character from Widows AD Name

I want to display Active Directory user name in my dashboard using label or textbox. How to get current AD name and display in label or textbox...? For Example my current Windows AD name would be "...
Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    Here you go:

     

    UNam =
    VAR Finddelimiter =
    FIND ( "@", USERPRINCIPALNAME (), 1 )
    VAR DomainName =
    MID ( USERPRINCIPALNAME (), 1, Finddelimiter - 1 )
    VAR FindDelimiterDot =
    FIND ( ".", DomainName, 1 )
    VAR FirstName =
    MID ( DomainName, 1, FindDelimiterDot - 1 )
    VAR LastNameInitial =
    MID ( DomainName, FindDelimiterDot + 1, 1 )
    RETURN
    UPPER ( LEFT ( FirstName, 1 ) )
    & RIGHT ( FirstName, LEN ( FirstName ) - 1 ) & " "
    & UPPER ( LastNameInitial )

PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

Ok, Try this:

 

UName = VAR FindSlash = FIND("\",USERNAME(),1)
return
MID(USERNAME(),FindSlash+1,LEN(USERNAME()))
saivina2920's avatar
saivina2920
Icon for Post Prodigy rankPost Prodigy
4 years ago

Ok..You are correct to get windows user name (It is windows user account id). But, It doesn't contain any user full name.

If we want to get user name from AD, I think "sn" is the field name.

Or

we can user userprincipalname. It contains mail id along with domain.

For example, USERPRINCIPALNAME is "[email protected]".

To get final user name we can use this mail id and split the name of the mail id.

Final Name is " Joseph J" is the result...

Is is possible from mail id ("[email protected]")  to get the above name "Joseph J").

I think the above step is easy way to get the name of the user..

What is you suggestion pls...?

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    4 years ago

    You can try this if it solves your purpose:

     

    UNam = VAR Finddelimiter = FIND("@",USERPRINCIPALNAME(),1)
    return
    MID(USERPRINCIPALNAME(),1,Finddelimiter-1)
    • saivina2920's avatar
      saivina2920
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

      Ok..Is there any DAX measure to split again from then name..?

      I have "[email protected]" and return to Joseph.Johnson.

      From this, again i want one more split and finally name would be Joseph J (I want to remove dot(.) and second name should be the initial only.

      so final name is "Joseph J"...?

      • PC2790's avatar
        PC2790
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Here you go:

         

        UNam =
        VAR Finddelimiter =
        FIND ( "@", USERPRINCIPALNAME (), 1 )
        VAR DomainName =
        MID ( USERPRINCIPALNAME (), 1, Finddelimiter - 1 )
        VAR FindDelimiterDot =
        FIND ( ".", DomainName, 1 )
        VAR FirstName =
        MID ( DomainName, 1, FindDelimiterDot - 1 )
        VAR LastNameInitial =
        MID ( DomainName, FindDelimiterDot + 1, 1 )
        RETURN
        UPPER ( LEFT ( FirstName, 1 ) )
        & RIGHT ( FirstName, LEN ( FirstName ) - 1 ) & " "
        & UPPER ( LastNameInitial )