teaser
Albato Embedded, the AI-first iPaaS, is officially live on Product Hunt!Support our launchright

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 Softr to Albato
4 min. read

How to Connect Softr to Albato

By connecting Softr with Albato, you can automate data flows and integrate with over 800+ apps, including AI tools like ChatGPT and Claude.

How to Connect Cognito Forms to Albato
4 min. read

How to Connect Cognito Forms to Albato

By connecting Cognito Forms with Albato, you can automate form submissions, sync data across 800+ apps, including AI tools, and streamline your lead collection process.

How to Control AI Agents with Automation Flows
11 min. read

How to Control AI Agents with Automation Flows

In this article, you will learn how you can control AI agents with automation flows for low precision and high precision tasks.

How to Connect Passcreator to Albato
3 min. read

How to Connect Passcreator to Albato

By connecting Passcreator to Albato, you can automate your customer engagement and loyalty programs.

How to Connect Grist to Albato
3 min. read

How to Connect Grist to Albato

Connect Grist with other apps, including AI tools, using Albato, to automate your marketing tasks and streamline your data workflow.

Giftsenda Automates Mass Gifting with Albato Embedded
Embedded
3 min. read

Giftsenda Automates Mass Gifting with Albato Embedded

Giftsenda, the global gifting platform, has partnered with Albato to offer powerful embedded integrations that automate and effortlessly scale gifting.

How to Connect ConvertBox to Albato
4 min. read

How to Connect ConvertBox to Albato

By connecting ConvertBox to Albato, you can automate lead and conversion workflows.

How to Connect ZenRows to Albato
4 min. read

How to Connect ZenRows to Albato

By connecting ZenRows to Albato, you can automate your data workflows and send parsed content directly to your preferred tools.

How to Connect NocoDB to Albato
4 min. read

How to Connect NocoDB to Albato

By connecting NocoDB with Albato, you can automate data updates and streamline internal processes.

How to Connect Pagemaker to Albato
4 min. read

How to Connect Pagemaker to Albato

By connecting Pagemaker to Albato, you can automate lead collection and streamline your marketing workflow.

Choosing the Right Tool: A Comparison of Top GenAI Models
21 min. read

Choosing the Right Tool: A Comparison of Top GenAI Models

In this article, you will find the comparison of top genAI models, including ChatGPT, Gemini, Claude, and others with pros, cons, and use cases.

How to Connect Todoist to Albato
3 min. read

How to Connect Todoist to Albato

By connecting Todoist with Albato, you can automate task creation, synchronize deadlines, and streamline your daily workflow.