Regex for search and replace

In the report editor in Layout the detailed configuration for a column allows to search and replace by regular expressions.

Here is an example:



  • The regeular 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 in the bottom of the form, to test your regular expression instantly.


Regular expressions are ver powerful. But they are not always intuitive and for sure there is so much more to explain. There please use other sources to dive deeper into this subject.

A good starting point is this website:

regular expressions 101

There use ECMAScript(JavaScript) to develope your regular expressions - like the one from above:


Lookup common tokens in the bottom right corner area:


Back to top