replacemultiple(
replacemultiple(
TEXT
,
OLD
,
NEW
,
SEPARATOR
)

The replacemultiple( function replaces multiple words and phrases in a text value.

Parameters

This function has four parameters:

text – is the item of text that you want to search through and possibly replace part of.

old – is an array of characters, words or phrases that you want to search for and replace. Each entry is separated from the next by the separator character.

new – is an array of new characters, words or phrases that you want to substitute for the old characters, words or phrases. This array must have the same number of items as the old parameter. The replacemultiple( function will scan through the text parameter. When it finds an item in the old parameter, it will replace that item with the corresponding item in the new parameter.

separator – is the separator character for both arrays (both must use the same separator character). This should be a single character.

Description

The replacemultiple( function is similar to the replace( function. However, instead of simply replacing one word or phrase with another, the replacemultiple( function takes an entire list of words or phrases and replaces them with the corresponding words and phrases in a second list. (In the current version of Panorama the replace( function can also perform multiple replacements, but it does so with multiple parameters instead of with a Text Array).

    replacemultiple("Medford, OR",
        "AK;AZ;CA;NV;OR;WA",
        "Alaska;Arizona;California;Nevada;Oregon;Washington",
        ";") ☞ Medford, Oregon
    replacemultiple("Walla Walla, WA",
        "AK;AZ;CA;NV;OR;WA",
        "Alaska;Arizona;California;Nevada;Oregon;Washington",
        ";") ☞ Walla Walla, Washington
    replacemultiple("Sedona, AZ",
        "AK;AZ;CA;NV;OR;WA",
        "Alaska;Arizona;California;Nevada;Oregon;Washington",
        ";") ☞ Sedona, Arizona

See Also

- @regex --
- search( --
- batchreplace -- performs multiple find and replace operations on a piece of text.
- batchreplace( -- performs multiple find/replace operations on a piece of text.
- croptext( -- crops text to a specified length. If the text was already shorter than the specified length, it is left unchanged. If it is longer, the text is cut off and an ellipsis is added on the end.
- percentescape( -- encodes specified characters using percent encoding.
- percentunescape( -- decodes text that contains percent encoding.
- regexreplacefirst( -- replaces the first occurrence of a regular expression pattern with new text.
- regexreplacefirstexact( -- replaces the first occurrence of a regular expression pattern with new text.
- replace( -- replaces text with new text.
- replacefirst( -- replaces the first occurence of some text with new text.
- sandwich( -- assembles a text item from three smaller items.
- strip( -- strips off leading and trailing blanks and other whitespace (carriage returns, tabs, etc.)
- stripchar( -- extracts characters you don't want from a text item.
- stripdiacriticals( -- strips diacritical marks from text.
- stripprintable( -- strips non-printable characters from text.
- striptoalpha( -- removes everything but alphabetic letters from a text item.
- striptonum( -- removes everything but numeric digits from a text item.
- urldecode( -- decodes text that contains percent encoded characters.
- urlencode( -- converts text into a legal URL (by converting spaces into `%20`). WARNING: THIS FUNCTION IS OBSOLETE.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0