substitute
Replace text by content (substring matching).
Syntax
Section titled “Syntax”v = substitute(text, old_text, new_text, instance_num)Description
Section titled “Description”Returns text with old_text replaced by new_text. Without instance_num, replaces every occurrence; with it, replaces only the instance_num-th occurrence (1-based).
Examples
Section titled “Examples”substitute('1-2-3-4', '-', '/') % '1/2/3/4'substitute('1-2-3-4', '-', '/', 2) % '1-2/3-4'