SWAP Function

Replaces a substring with a new substring.

This function is provided for compatibility with other MultiValue systems.

Syntax

SWAP(oldString, oldSubstr, newSubstr{, count{, startOccur}})

Syntax Elements

oldString The original string.

oldSubstr The substring in the original string to be changed.

newSubstr The replacement substring.

count The number of occurrences of oldSubstr to replace with newSubstr. If omitted or less than 1, all occurrences are replaced.

startOccur The number of the first occurrence to replace. If omitted or less than 1, the first occurrence is assumed.

Return Value

SWAP returns the modified string.

Comments

SWAP is identical in operation to the CHANGE function.