Search

Formulas - How to replace a text within a field?

Svitlana Zh.
Svitlana Zh.
  • Updated

This Replace text formula can be used to replace a value XX with another value YY.

  • Field- the source field to use
  • Search - the value XX to search in the source field
  • Replace - the value YY that will be used to replace the occurrences of XX specified in Search

You can also use the __EMPTY and __BLANK_SPACE keywords to replace with empty strings and blank spaces. Always use the double underscore before the two keywords.

Let’s see some examples of execution:

EXAMPLE 1

You would like to replace all the occurrences of “, “ with the “;” symbol coming from the field Campaign.

You should configure the function as shown below:

  • Field- Campaign
  • Search - ,
  • Replace - {{;}}

Image

EXAMPLE 2

You need to replace the Form Name field value with one that contains underscores between words. The Replace text formula will search for blank spaces in the value of the Form Name field and will replace them with an underscore.

Image

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.