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.

 

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.

 

Examples of custom value parsing patterns

 

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.

1.1.png

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

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

The result will look like this:

1.2.png

 

Case 2: Remove tags from an email

What to replace:

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

Replace with: Space.

1.3.png

 

Case 3: Extracting a domain from a URL

What to replace: ^https?://([^/]+)/.*$

Replace with: $1

This pattern extracts the domain name from a full URL that contains a path or parameters. For example, from https://example.org/id25 you’ll get: example.org


Tools

Join our newsletter

Hand-picked content and zero spam!

Related articles

Show more
CustomerX Embeds Albato to Drive Expansion
Embedded
3 min. read

CustomerX Embeds Albato to Drive Expansion

With Albato Embedded, CustomerX’s users can now extract data from the platform and easily connect it to other tools, enhancing integration and the strategic use of information.

How to Leverage AI Agent Crews for Business Transformation
6 min. read

How to Leverage AI Agent Crews for Business Transformation

Discover how AI agent crews can automate complex workflows and drive business transformation. Learn the key differences between AI agents and agent crews, plus practical implementation tips.

Albato Embedded vs Prismatic vs Tray.io: Full Comparison
10 min. read

Albato Embedded vs Prismatic vs Tray.io: Full Comparison

Compare Albato Embedded vs Prismatic vs Tray.io by features, pricing, white-labeling, UX, and support to find the best embedded iPaaS for your business.

Strategies That Drive Growth
3 min. read

Strategies That Drive Growth

Tools, tips, and tricks to help your team do less busywork and make every decision count.

Model Context Protocol Clearly Explained
4 min. read

Model Context Protocol Clearly Explained

In this article, you will learn how the Model Context Protocol (MCP) is reshaping enterprise AI. Albato’s AI Product Owner, Alex Fillimonov, will share his insights on why MCP is important for SaaS.

5 Ways to Automate Claude with Albato
4 min. read

5 Ways to Automate Claude with Albato

In this article, you will learn five practical ways to connect and automate Claude AI with Albato. Learn how to boost workflows, integrate apps, and streamline business tasks.

5 Best No-Code Web Scrapers For Online Businesses
6 min. read

5 Best No-Code Web Scrapers For Online Businesses

Discover 5 top no-code web scrapers for online businesses. Automate competitor tracking, SEO monitoring, and market research without coding.

How to Connect Bhuman AI to Albato
4 min. read

How to Connect Bhuman AI to Albato

Connect BHuman with Albato to integrate it with over 1000+ apps, including AI services like ChatGTP and Grok.

How to Connect Darwin AI to Albato
4 min. read

How to Connect Darwin AI to Albato

Connect Darwin AI with Albato to integrate it with over 1000+ apps.

State of Integrations Report 2025: Key Trends and Strategic Insights
5 min. read

State of Integrations Report 2025: Key Trends and Strategic Insights

In this report, you will learn about the 2025 state of integrations in 2025 with data, trends, and recommendations. Learn how businesses can leverage integrations to boost efficiency and stay competitive.

How to Connect to Coveto to Albato
4 min. read

How to Connect to Coveto to Albato

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

How to Connect Privy to Albato
4 min. read

How to Connect Privy to Albato

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