Replace all instances

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

Type: Import/Export Rule

Description: Searches the cell value and replaces all instances of the found string with a new value.

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