How to set up Data Cropping tool

Albato: Data Cropping tool
Tools
·
7/7/2023
·
2 min. read

In this article

This tool works like a pair of scissors, allowing you to cut data from any set of values. You can cut half of the line (e.g. from the beginning to the middle) or a value in the middle of the line (e.g. from the 3rd to the 5th character).

Let's look at the functionality of the tool using the following example.

We receive information about Google's click ID (called GCLID) from some source (e.g. an online store, InSales). The information comes in the form of the following string: http://www.site.com/?gclid=1234

From this string, we just need to get the numeric value - 1234 - which we'll pass to SendPulse. To do this, we will use the "Data Cropping" tool.

Step 1. Add the tool

First you need to open your automation, click the + button between the steps and select the "Tool" option. Then select the "Data cropping" tool.

Data cropping (1).png

Step 2. Configure the tool

In this step we will configure the tool.

  • Create a name for the data set you want to format.
  • Select a value for the data processing. In our case, we will select the "URL from where they came to the website" field of the InSales trigger as the value.
  • Select the data extraction direction, i.e. choose where to start the extraction: from the beginning or from the end. Let's follow the direction from the beginning. This will make the system run the algorithm from left to right. If we choose the "from the end" option, the algorithm will be mirrored and run from right to left.
  • Select the type of data cropping. There are 2 types: "By number of characters" and "By a specified character". In our case we will choose the "By a specified character" type.

Data cropping 1.png

Next we configure the data cropping algorithm.

Data cropping 2.png

  • Here you need to specify "From which character to start cropping" (i.e. the beginning of the data we want to transfer later).

For our example, based on the InSales and SendPulse integration, we entered the following configuration: specify the value "d=". So the result of the tool will be 1234

  • We do not enter a value in the "Up to which character to cut" field, but we mark the "Cut to end" field. Thus, for this parameter the algorithm will understand that it is necessary to get the data from the position specified in topic 5 to the end of the string.

To use the result of the Data Cropping tool, you must go to the settings of the next step and select the "Result" value for the field from the previously configured Albato step.

You can use this tool to solve a variety of tasks.

For example, extract a country or operator code from a phone number, extract a region code from a car license plate, extract a token from a request string, etc.


Tools

Join our newsletter

Hand-picked content and zero spam!

Related articles

Show more
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.

Grok 4, GPT-5, Gemini, and Claude Opus 4.1―All the Recent Updates
13 min. read

Grok 4, GPT-5, Gemini, and Claude Opus 4.1―All the Recent Updates

In this article, you will find an in-depth comparison of Grok, ChatGPT, Gemini, and Claude. Discover their strengths, weaknesses, and which AI chatbot fits your business needs best.

Testing Steps Tool
5 min. read

Testing Steps Tool

Testing Steps tool allows you to run a test on each individual step and view Samples of incoming data

Branching Tool
5 min. read

Branching Tool

A new tool in Albato allows you to run different scenarios within a single automation depending on specific conditions.

How AI Is Changing SaaS Product Design
7 min. read

How AI Is Changing SaaS Product Design

In this article, you’ll learn how to design SaaS products in the age of AI. We’ll discuss UX patterns and practical tips to help you create better products.

Best Sales Automation Apps for Faster Growth
10 min. read

Best Sales Automation Apps for Faster Growth

In this article, you will learn about the best sales automation apps to save time, close more deals, and boost team productivity. Compare features, pricing, and integrations.

Smarter Automations with Workflow Management Software
2 min. read

Smarter Automations with Workflow Management Software

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

QuickBooks CRM Integration | Boost Sales & Automate Accounting
5 min. read

QuickBooks CRM Integration | Boost Sales & Automate Accounting

In this article, you will learn how QuickBooks CRM integration can streamline your sales, invoicing, and customer data. Save time and grow your business with a seamless CRM-QuickBooks connection.

Best Productivity Apps 2025 – Streamline Your Daily Tasks
13 min. read

Best Productivity Apps 2025 – Streamline Your Daily Tasks

In this article, you will learn about the top productivity apps—task managers, timers, note tools, and more—to streamline your daily workflow and boost efficiency in 2025.

How to Connect Green API to Albato
4 min. read

How to Connect Green API to Albato

Connect Green API with Albato to integrate it with over 800+ apps, including AI tools like ChatGPT and Gemini.

How to Connect AskNicely to Albato
3 min. read

How to Connect AskNicely to Albato

Connect AskNicely with Albato to integrate it with over 800+ apps, including AI tools like Gemini and Grok.

Check if a Contact Already Exists on the Platform
5 min. read

Check if a Contact Already Exists on the Platform

You will learn what to do when you want to message a contact who signed up through a form on another platform, such as Facebook Ads.