How to set up Data Cropping tool

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

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

Related articles

Show more
How to Connect Typeflo to Albato
5 min. read

How to Connect Typeflo to Albato

By connecting Typeflo and Albato, you can automate document creation, content delivery and streamline your management process.

3 Ways How to Schedule Instagram Posts
Instagram for Business
15 min. read

3 Ways How to Schedule Instagram Posts

In this article, you will learn how to schedule Instagram posts using native scheduling, Meta Business Suite, and third-party apps and share tips on Instagram scheduling.

How to Optimize Your Workflows to Improve Efficiency
5 min. read

How to Optimize Your Workflows to Improve Efficiency

In this article, you will learn how to optimize your workflows for higher efficiency. The goal is to devise a system that allows employees to start the week with focus and get more done faster.

How to Connect Wave to Albato
3 min. read

How to Connect Wave to Albato

By connecting Wave and Albato, you can automate creating invoices, updating financial data, and managing transactions, saving your time and reducing manual work.

How to Connect CraftMyPDF to Albato
2 min. read

How to Connect CraftMyPDF to Albato

By connecting CraftMyPDF and Albato, you can streamline document creation and delivery.

How to Connect PlatoForms to Albato
3 min. read

How to Connect PlatoForms to Albato

By using PlatoForms and Albato, you can easily share signed PDFs to cloud storage, trigger email notifications, and sync collected data with your internal tools. Just follow these steps to integrate PlatoForms into your workflow.

How to Connect Fiken to Albato
4 min. read

How to Connect Fiken to Albato

By integrating Fiken with Albato, you can automate your financial processes and simplify workflows. Just follow the steps below to set it up.

How to Connect Trackdesk to Albato
4 min. read

How to Connect Trackdesk to Albato

By connecting Trackdesk and Albato, you can easily set up automations that streamline tracking and reporting of your affiliate marketing campaigns, as well as automate partner payouts. Just follow the steps below to set it up.

How to Connect Printify to Albato
3 min. read

How to Connect Printify to Albato

By connecting Printify and Albato, you can easily set up automations that simplify order processing. Just follow the steps below to set it up.

SaaS Integrations: Benefits, Challenges, and Best Practices
15 min. read

SaaS Integrations: Benefits, Challenges, and Best Practices

In this article, you will learn the essentials of SaaS integrations, including benefits, challenges, approaches, and future trends to optimize your business operations.

How Chatfuel Cut Churn by 25% and Integration Dev Time by 80% with Albato Embedded
Embedded
5 min. read

How Chatfuel Cut Churn by 25% and Integration Dev Time by 80% with Albato Embedded

To overcome its challenges, Chatfuel chose Albato for its embedded white-label integrations, specifically designed for SaaS platforms.

How to Connect Google Contacts to Albato
3 min. read

How to Connect Google Contacts to Albato

By integrating Google Contacts with Albato, you can automate the exchange of key data between teams, partners, and clients. Follow the steps below to set it up.