SUBSTITUTE - j5 - 30 - Administration & Configuration - Hexagon

j5 IndustraForm Designer Reference

Language
English
Product
j5
Search by Category
Administration & Configuration
j5 Version
30

Substitutes new text for old text in a string.

= SUBSTITUTE(text, old_text, new_text[, occurrence])

text - The text in which partial words are to be replaced.

old_text - The partial string to be (repeatedly) replaced. This supports regular expressions.

new_text - The text which is to replace the text string. This supports regular expressions.

occurrence - Which occurrence of the old text is to be replaced.

The "." character in a regular expression is treated as a wildcard and will match any character. For example:

=SUBSTITUTE("secret", ".", "x") results in “xxxxxx”

To replace an actual "." character without matching other characters, escape it by inserting a "\" before the character. For example:

=SUBSTITUTE("10.59", "\.", ":") results in “10:59”

For more advanced regular expressions, we recommend that you search for Regular expression examples using your chosen search engine.