Articles on: Function Reference

Regex for Search and Replace

In the report editor in Layout , the Format Options for a column allow you to search and replace using 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: 11/03/2025

Was this article helpful?

Thank you!