SubstituteChars()

Summary

Returns the input string with all occurrences of the characters listed in the find string replaced with the characters in the replacement string.

 

Changes

Added to Version 2018.

 

Syntax

new_string = SubstituteChars(string input_str, string find_str, string repl_str)

 

Argument	Contents
input_str	The input string
find_str	The characters to be located and replaced
repl_str	The new characters that are to replace the find_str characters

 

Returns

A string where the characters in find_str are replaced with the characters in repl_str.

 

Notes

• If repl_str has the same number of characters as find_str, the first character of find_str is replaced with the first character of repl_str, etc.

• If repl_str has one character, all characters of find_str are replaced with that character.

• If repl_str is null, all characters of find_str are removed.

• SubstituteChars() is useful for standardizing accents.

Examples

 

s = SubstituteChars("cavolate","aeou","i")	// Returns "civiliti"
s = SubstituteChars("cavolate","aeou","")	// Returns "cvlt"
s = Upper(SubstituteChars("QUéBEC YUCATáN MéXICO","éá","ea"))	// Returns "QUEBEC YUCATAN MEXICO"

 

 

See Also

Function	Summary
Position()	Returns the position of a substring within a string
PositionFrom()	Search for the first occurrence of a substring within a string, starting the search at a designated position
PositionTo()	Search for the last occurrence of a substring within a string, ending the search at a designated position
Substitute()	Replaces a matching substring with a new string
Substring()	Extracts a portion of a string