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

Related articles

Show more
Want to learn automation tricks?
2 min. read

Want to learn automation tricks?

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

How to Connect Snowflake to Albato Using OAuth2
3 min. read

How to Connect Snowflake to Albato Using OAuth2

By connecting Snowflake to Albato you can streamline data flows across multiple business apps without manual effort.

How to Connect Apollo to Albato
3 min. read

How to Connect Apollo to Albato

Create integrations with Apollo in Albato to automate lead generation, streamline contact management.

AI Agent Useful Case Studies: Enhancing Business Operations
8 min. read

AI Agent Useful Case Studies: Enhancing Business Operations

In this article, you'll learn what AI agents are, how they work, and how they can add value through useful case studies in different niches from content and marketing to healthcare and retail.

How to Scale a Business with No Code
8 min. read

How to Scale a Business with No Code

In this article, you’ll learn how to scale a business with no code and choose the right tools for the job.

What Are White-Label Integrations for SaaS
7 min. read

What Are White-Label Integrations for SaaS

In this article, we explain what white-label integrations for SaaS are, explore their benefits and drawbacks.

Work Smarter, Not Harder
2 min. read

Work Smarter, Not Harder

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

In-house vs. Unified API vs. Embedded iPaaS: Key Differences & Best Use Cases
8 min. read

In-house vs. Unified API vs. Embedded iPaaS: Key Differences & Best Use Cases

In this article, you will learn the key differences between in-house integration development, Unified APIs and Embedded iPaaS to choose the best strategy for your SaaS product.

What the Ansoff Growth Matrix Is and How to Use It
8 min. read

What the Ansoff Growth Matrix Is and How to Use It

In this article, you will learn the definition of the Ansoff Growth Matrix, how it works, and how to use it for strategic planning in your business.

White-Label Albato Embedded vs. Zapier Embed: Solution Comparison
6 min. read

White-Label Albato Embedded vs. Zapier Embed: Solution Comparison

In this article, you will learn about the features and pricing fo Albato Embedded vs Zapier to help you find the best white-label integration solution for your needs.

Big News for AI Enthusiasts
2 min. read

Big News for AI Enthusiasts

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

Top 15 Tools for Outreach 2025
20 min. read

Top 15 Tools for Outreach 2025

In this article, you will find 15 top tools for outreach that help with contact enrichment, lead scoring, and more.