cfSubstitudeWildCard ( text ; searchString ; replaceString ; start )

Replace all occurrences with wildcard

Be the first to rate this function Log in to vote

Kadir Kaleli - Show more from this author
Yordam
http://www.yordam.com

Sample input:

Sample output:

textXX textXX textXXbc textXXx
textX textX text|abc text|cx
wo text wod text
word tY world tY
wor text worl text

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

Case ( Left(searchString; 1 ) ≠ "@" and  Left(searchString; 1 ) ≠ "#" ;

Let ( [
searchString = Substitute ( searchString ; ["@" ; "Ω"] ; ["#" ; "≈"] );
_searchLenght = Length ( searchString );
_searchStart = Position ( text ; Left( searchString ; 1) ; start ; 1);
_searchWord = Middle ( text ; _searchStart ; _searchLenght );

_isvalid = PatternCount ( cfSubstitudeWildCardIsNumOrText (searchString; _searchWord ) ; "0" );

text = If (_isvalid = 0 ; Replace ( text ; _searchStart ; _searchLenght ; replaceString ) ; text );
start = If ( _isvalid ≠ 0 ; start + 1; start );

text = If ( _searchStart > 0   ;  cfSubstitudeWildCard( text ; searchString ; replaceString; start)  ; text )
] ; 
text
 )
;
text
)

Replace with wildcard
for string use @
for number use #

Use these function together:

cfSubstitudeWildCardIsNumOrText ( _text1 ; _text2 )

Case( Length(_text1) > 0 ;
Case (
Left(_text1;1) = Left(_text2;1) ; 1 ;
Left(_text1;1) = "Ω" ; 1 ;
Left(_text1;1) = "≈" and GetAsNumber(Left(_text2;1)) ≠ "" ; 1 ; 0
) & cfSubstitudeWildCardIsNumOrText (Right(_text1;Length(_text1) -1 ); Right(_text2;Length(_text2) -1 ) )
; _text1
)

Comments

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

cfSubstitudeWildCard ( text ; searchString ; replaceString ; start )

Comments

Support this website.

Support this website.