Ex@ct ( originalText ; comparisonText ; wildChar )

Compares two text strings, allowing for a wildcard character.

Average rating: 4.6 (28 votes) Log in to vote

Michael Horak - Show more from this author
*COMMENT Visual Realisation

Sample input:

Ex@ct ( "Gray" ; "Gr@y" ; "@" )

Ex@ct ( "Don" ; "@on" ; "@" )

Ex@ct ( "Bron" ; "@on" ; "@" )

Ex@ct ( "555-123-4567" ; "555-###-4567" ; "#" )

Sample output:

1

1

0

1

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

/*
Ex@ct function

Author
*COMMENT Visual Realisation

Format
Ex@ct ( originalText ; comparisonText ; wildChar )

Parameters
originalText - any text expression or text field;
comparisonText - any text expression or text field;
wildChar - any one character

Data type returned
number

Description
Compares the contents of originalText to comparisonText and returns 1 (True) if the contents match, 0 (False) otherwise. The comparisonText may contain one wildcard character for each unknown character.

February 29, 2012
*/

Let ( [
pos = Position ( comparisonText ; wildChar ; 1 ; 1 )
] ; 
Case ( 
pos and Length ( originalText ) ≥ pos ; Ex@ct ( originalText ; Replace ( comparisonText ; pos ; 1 ; Middle ( originalText ; pos ; 1 ) ) ; wildChar ) ;
Exact ( originalText ; comparisonText )
)
)

Compares the contents of originalText to comparisonText and returns 1 (True) if the contents match, 0 (False) otherwise. The comparisonText may contain one wildcard character for each unknown character.

Comments

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

Ex@ct ( originalText ; comparisonText ; wildChar )

Comments

Support this website.

Support this website.