How to use Value Parser (Regular Expressions)

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

In this article

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

Join our newsletter

Hand-picked content and zero spam!

Related articles

Show more
Zapier vs. Make vs Albato: Full Comparison
6 min. read

Zapier vs. Make vs Albato: Full Comparison

In this article, you will learn how Zapier, Make, and Albato compare to each other to see which SaaS automation platform suits your needs. Explore capabilities, pricing, features, and use cases.

Our Automation Builder Has Just Leveled Up
3 min. read

Our Automation Builder Has Just Leveled Up

Explore what’s new in Albato: features, apps, and improvements

Best Accounting Apps to Manage Your Business Finances
7 min. read

Best Accounting Apps to Manage Your Business Finances

In this article, you will learn about the top accounting apps like Sage, QuickBooks, Zoho Books, and more to simplify bookkeeping, automate workflows, and grow your business.

Grok AI Use Cases: Gmail, WhatsApp, CRM & More
5 min. read

Grok AI Use Cases: Gmail, WhatsApp, CRM & More

In this article, you will learn some practical Grok AI automation use cases, from Gmail and WhatsApp to CRM queries and Google Home integration.

HubSpot vs. Pipedrive: Which CRM to Use
7 min. read

HubSpot vs. Pipedrive: Which CRM to Use

In this article, you will find a comparison between HubSpot and Pipedrive CRM tools in features, pricing, and usability for sales and marketing teams.

How to Connect Deskera to Albato
3 min. read

How to Connect Deskera to Albato

Connect Deskera with Albato to integrate it with over 1000+ apps, including AI tools like ChatGPT and Grok.

How to Connect Sympla to Albato
4 min. read

How to Connect Sympla to Albato

Connect Sympla with Albato to integrate it with over 1000+ apps, including AI tools like ChatGPT and Claude.

How to Connect Asana to Albato
3 min. read

How to Connect Asana to Albato

Connect Asana with Albato to integrate it with over 1000+ apps, including AI tools like and Claude.

How to Connect Yahoo Mail to Albato
3 min. read

How to Connect Yahoo Mail to Albato

Connect Yahoo Mail with Albato to integrate it with over 1000+ apps, including AI tools like ChatGPT and Gemini.

Best AI Automations with Albato: ChatGPT, Claude, Gemini
10 min. read

Best AI Automations with Albato: ChatGPT, Claude, Gemini

In this article, you will find some examples of powerful AI automations with ChatGPT, Claude, and other LLMs you can set up with Albato to boost productivity and streamline your business processes effortlessly.

How to Connect BlueJeans Meetings to Albato
4 min. read

How to Connect BlueJeans Meetings to Albato

Connect BlueJeans with Albato to integrate it with over 1000+ apps, including AI tools like ChatGPT and Gemini.

How to Connect Olark to Albato
4 min. read

How to Connect Olark to Albato

Connect Olark with Albato to integrate it with over 1000+ apps, including AI tools like ChatGPT and Gemini.