thisSideOfThat ( text, character ; direction )

Get whats to the left or right of the specified character in the text field. It takes 3 parameters. text, character,direction

Be the first to rate this function Log in to vote

Binu Alexander - Show more from this author
ASC,
https://www.linkedin.com/in/drbinualexander/

Sample input:

thisSideOf( "John Doe" ; " " ; "left" ) // Returns "John"

thisSideOf( "user@example.com" ; "@" ; "left" ) // Returns "user"

thisSideOf( "No character here" ; "," ; "left" ) // Returns ""

thisSideOf( "Invalid direction" ; "d" ; "center" ) // Returns ""

Sample output:

Jonh, user and, "","" respectively

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

// Function Name: thisSideOf
// Parameters: text, character, direction
Let([
  charPosition = Position( text ; character ; 1 ; 1 );
  textLength = Length( text )
];
  Case(
    charPosition = 0 ; "";
    direction = "left" ; Left( text ; charPosition - 1 );
    direction = "right" ; Right( text ; textLength - charPosition );
    ""
  )
)

Get whats to the left or right of the specified character in a text field.

thisSideOf extracts text either to the left or right of a specified character in a given string.

It takes three parameters: the text to search, the character to find, and the direction ('left' or 'right') to extract from.

Comments

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

thisSideOfThat ( text, character ; direction )

Comments

Support this website.

Support this website.