Infopath's built in Username() function returning "i:0#.w|Domain\UserName" instead of just UserName?

Question

How can I modify the UserName() return string to display only the username as opposed to "i:0#.w|Domain\UserName"?

When I had the same form in my development environment it returned Domain\UserName and none of the prefix characters (i:0#.w|). Once I moved it to the production though I get this now: i:0#.w|Domain\UserName

I am open to using other alternatives as well.

Answer 1

Try a substring after "\" for the user name, or after "|" for the domain and user name.

http://office.microsoft.com/en-us/infopath-help/functions-in-infopath-HP001155281.aspx

Answer 2

The reason you're seeing this is that your production farm uses Claims AuthN whereas your dev enviroment the classic mode. You should probably make your code handle both scenarios.

Here are some details about the claims encoding: http://www.wictorwilen.se/Post/How-Claims-encoding-works-in-SharePoint-2010.aspx

Answer 3

While researching this myself, I found a solution that might be a bit better than a substring. You might want to try the following:

SPClaimProviderManager manager = SPClaimProviderManager.Local;

if (manager != null)
{
    if (SPClaimProviderManager.IsEncodedClaim(encodedString))
        username = manager.DecodeClaim(encodedString).Value;
    else
        username = encodedString;
}

Answer 4

You will have to parse the username from the returned string as explained by RJ above. But you might want to show the Display name instead of user name. you will need to query the user profile service from infopath to extract the Display Name for that username().

Answer 5

This is an alternative solution: http://zimmergren.net/technical/tip-getting-the-normal-domain-username-from-the-claims-username-in-sharepoint-2013