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:

regex

Explanation:

  • 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

Tip

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

Note

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:

regex-builder

Lookup common tokens in the bottom right corner area:

lookup-regex

Back to top