CALC.substitute(text, old_text, new_text, instance_num)
Substitutes New_text for Old_text in a text string. Use this function when you want to replace specific text in a text string; use replace() when you want to replace any text that occurs in a specific location in a text string. Text is the text or the reference to a cell containing text for which you want to substitute characters. Instance_num specifies which occurrence of Old_text you want to replace.
Example
CALC.substitute('asd/pqr/xyz','/','-', 1);
// returns asd-pqr/xyz (substitutes instance 1 of '/' with '-')
| << CALC.search(find_string, within_string, start_num) | © 1996-2013 InetSoft Technology Corporation (v11.5) | CALC.t(value) >> |