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.4) CALC.t(value) >>