Replace all instances

Replace all instances of the specified text with the new value.

Type: Import/Export Rule

Example: Replace all delimiters
  • Cell value: 1, 234, 567.89

  • Rule values:

    • Replace text: , (a single comma)

    • With text: (an empty space)

  • Result: 1 234 567.00

Example: Replace all <p> and </p> tags

Note: This case cannot be achieved with only one iteration. If the specified text cannot be modified with a single iteration of a rule, additional rules should be created to modify the text.

  • Cell value: <p>value</p>

  • Rule values:

    • Replace text: <p>

    • With text: (an empty space)

  • Result: value</p>

After adding this rule, add a second rule to replace all </p> tags

Last updated

#48:

Change request updated