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

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 )

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

    It's perfect.