Articles on: Function Reference

Regex for Search and Replace

The Search and Replace function allows you to find specific words or character sequences in your text or data and replace them with alternatives.

Regular Expressions (Regex) go a step further by letting you define patterns in text. For example, you can use regex to identify all phone numbers with an international prefix—making it easy to standardize phone numbers across your reports.

For a step-by-step walkthrough, check out our YouTube Tutorial:

In the report editor in Layout , the Format Options for a column allow you to Search and Replace as well as Search and regular expressions.

Here is an example:

To check the settings, click “Test settings”:

Explanation:

The regular expression ^81|\+81
will search for a string starting with 81 or +81
and if found, the string will be replaced by 0

Use the "Test settings" function at the bottom of the form to instantly test your regular expression.

Regular expressions are powerful but not always intuitive. To explore this topic further, consider using external resources. A great starting point is regular expressions 101

Use ECMAScript(JavaScript) to develop your regular expressions ( 1 ) - like the example above,. You can also find common tokens ( 2 ) in the bottom right corner of the page.

Updated on: 29/09/2025

Was this article helpful?

Thank you!