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


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0