SubstituteValuesInText__cf ( _text ; _searchValues ; _replaceValues )

Substitutes multiple searchValues within text with the corresponding replaceValues.

Average rating: 4.2 (43 votes) Log in to vote

Steve Hearn
CoreSolutions Development
http://www.coresolutions.ca

Sample input:

SubstituteValuesInText__cf ( "ABCDE ABCDE¶ABCDE" ; "B¶D" ; "2¶4" )

Sample output:

A2C4E A2C4E¶A2C4E

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

Let(
    [
        _searchString = GetValue( _searchValues; 1 );
        _replaceString = GetValue( _replaceValues; 1 );
        _xchgList = Substitute( _text; _searchString; _replaceString );
        _countValues = ValueCount( _searchValues )
    ];
    Case(
        _countValues > 1;
        SubstituteValuesInText__cf(
            _xchgList;
            RightValues( _searchValues; _countValues - 1 );
            RightValues( _replaceValues; _countValues - 1 )
        );
        _xchgList
    )
)


/*
SubstituteValuesInText__cf function

Original Author (SubstituteValues: <http://www.briandunning.com/cf/851>)
Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net

Modified by Steve Hearn, CoreSolutions Development Inc
Aug. 7, 2008

Format
SubstituteValuesInText__cf ( _text ; _searchValues ; _replaceValues )

Parameters
_text - any text expression or text field
_searchValues - any return-delimited list of values to find in _text
_replaceValues - any return-delimited list of values to replace _searchValue with

Description
Substitutes multiple searchValues within _text with the corresponding replaceValues. The _searchValues and _replaceValues are intended to be a matched pair, typically the result of a List function. Originally developed to search for and replace strings defined in a table.

Example
_text: This is a sample letter with merge fields like <<firstName>> and <<orgName>> that are user-friendly field names. A table has a list of these user-friendly fields as well as their corresponding "real" field name.

_searchValues: <<firstName>>¶<<orgName>>

_replaceValues: <<CM__CON__Contact__102::firstName>>¶<<CM__ORG__Organization__107::orgName>>

output: This is a sample letter with merge fields like <<CM__CON__Contact__102::firstName>> and <<CM__ORG__Organization__107::orgName>> that are user-friendly field names. A table has a list of these user-friendly fields as well as their corresponding "real" field name.

*/

Description
Substitutes multiple searchValues within _text with the corresponding replaceValues. The _searchValues and _replaceValues are intended to be a matched pair, typically the result of a List function. Originally developed to search for and replace strings defined in a table.

Example
_text: This is a sample letter with merge fields like <> and <> that are user-friendly field names. A table has a list of these user-friendly fields as well as their corresponding "real" field name.

_searchValues: <>¶<>

_replaceValues: <>¶<>

output: This is a sample letter with merge fields like <> and <> that are user-friendly field names. A table has a list of these user-friendly fields as well as their corresponding "real" field name.

Comments

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

SubstituteValuesInText__cf ( _text ; _searchValues ; _replaceValues )

Comments

Support this website.

Support this website.