BaseAccountName ( AcctName )

Strips the domain name from the user account name when it is in UPN or domain\username format.

Be the first to rate this function Log in to vote

Matt C - Show more from this author

Sample input:

BaseAccountName(Get(AccountName))
or
BaseAccountName("username@domain.net")

Sample output:

username

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* This calculation will return the base account name without domain */

// Domain in user@domain.com pattern
If ( PatternCount ( AcctName; "@" ); 
	Left ( AcctName ; Position ( AcctName ; "@" ; 1 ; 1 ) - 1 ))
&

// Domain in domain\user pattern
If ( PatternCount ( AcctName; "\\" ); 
	Right ( AcctName; Length (AcctName) - Position (AcctName; "\\" ; Length (AcctName) ; -1 ) ))&

// Basis format with no domain
If ( PatternCount ( AcctName; "\\" ) = 0 and PatternCount ( AcctName; "@" ) = 0; AcctName)

When using External Authentication with a Microsoft Active Directory domain, depending on how the user logs in, Get(AccountName) may return the username in a number of different formats.

For example, Get(AccountName) may return:
username
domain\username
username@domain.net

This function strips out the domain name and returns only the base username.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

BaseAccountName ( AcctName )

Comments

Support this website.

Support this website.