How to use Value Parser (Regular Expressions)

Albato: Value Parser tool
Tools
·
5/3/2023
·
2 min. read

The Value Parser, or Regular Expressions, is an advanced way to search and replace text.

How to use value parser tool

In the tool's settings, you can specify:

what to replace: symbols, characters, words, custom sets (templates), etc.

replace with: symbols, character, custom sets (templates), etc.

While simple character search works like a standard "Find and Replace", Regular Expressions are great because you can search for multiple characters, exclude them, add rules, and more.

Here are some examples of custom search templates:

x|y — Searches for x or y

x(?=y) — Searches for x only if it's followed by y

[a-d] — Range of characters — Square brackets mean "any character from the list."

\w+@\w+.\w+ — Searches for email.

([0-3]\d).([01]\d).(\d{4}) — Searches for date in format dd.mm.yyyy

(8|+7|7)[0-9]{7,10} — Searches for phone number in format 8********** or +7**********.

There are countless templates and combinations to replace text, and you can find many resources online.

Here are some examples:

Case 1: Converting the date format from DD.MM.YYYY to YYYY_MM_DD.

Tool Settings: The "What to replace" and "Replace with" fields use custom templates.

Template: ([0-3]\d).([01]\d).(\d{4})

Replace with: $3_$2_$1.

Untitled.png

The result will look like this:

Untitled (1).png

Case 2: Remove tags from an email.

What to replace: <(/?[^>]+)>|(\n)|(\s{4,})

Replace with: Space.

Untitled (2).png


Tools