Omit ( text ; string )

This custom function omits the chars of the string from the given text, without any practical limitation.

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

Daniele Raybaudi - Show more from this author
ACI
http://www.aci.it

Sample input:

Omit ( "abcdefg" ; "af" )
Omit ( "a12345" ; "1234567890" )

Sample output:

bcdeg
a

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

/*
Omit ( text ; string ) custom function

Author: Daniele Raybaudi

This custom function omits the chars of the string from the given text, without any practical limitation.

*/

Let(
$cfOmit = $cfOmit + 1;
Case ( 
$cfOmit ≤ Length ( string ) ; Omit ( Substitute ( text ; Middle ( string ; $cfOmit ; 1 ) ; "" ) ; string ) ;
Let( $cfOmit = "" ; text )
)
)

This custom function omits the chars of the string from the given text, without any practical limitation.

Comments

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

Omit ( text ; string )

Comments

Support this website.

Support this website.