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
Product-Led Growth: 4 Strategies and Implementation Guide
Embedded
13 min. read

Product-Led Growth: 4 Strategies and Implementation Guide

In this article, you will learn what product-led growth (PLG) is and how it drives user acquisition, retention, and scalability on real-life examples.

Product updates we're excited about
3 min. read

Product updates we're excited about

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

DeepSeek Overview: Features, Benefits, Use Cases, and Alternatives
7 min. read

DeepSeek Overview: Features, Benefits, Use Cases, and Alternatives

DeepSeek overview covering key features, benefits, and use cases. Compare top alternatives to find the best AI-powered solution for automation and efficiency.

What Is an iPaaS? All About Integration Platform as a Service
Embedded
5 min. read

What Is an iPaaS? All About Integration Platform as a Service

An iPaaS is an integration platform as a service that helps businesses connect applications, data, and systems seamlessly for streamlined workflows.

Connect Digital Samba with Albato | Elevate Your Webinar Experiences
3 min. read

Connect Digital Samba with Albato | Elevate Your Webinar Experiences

Digital Samba is a powerful platform for hosting and managing webinars, designed with user-friendly features and scalability in mind. See how Albato can help you enhance the app’s usability!

Connect Intento with Your Favorite Apps | Optimize Your Translations with Albato
3 min. read

Connect Intento with Your Favorite Apps | Optimize Your Translations with Albato

Intento is an AI-powered platform for managing multilingual content and optimizing translation workflows. See how Albato can help you enhance the app’s usability!

How to connect ClickUp to Albato for seamless Integrations | ClickUp Integrations Guide
4 min. read

How to connect ClickUp to Albato for seamless Integrations | ClickUp Integrations Guide

Learn how to set up ClickUp integrations with Albato in our step-by-step guide. Unlock powerful ClickUp integrations & automate workflows to boost productivity.

Integrate Ortto with 800+ Apps | Enhance Your Marketing Automation with Albato
3 min. read

Integrate Ortto with 800+ Apps | Enhance Your Marketing Automation with Albato

Ortto redefines the landscape of marketing automation with its intuitive service that simplifies email marketing, customer journey mapping, and targeted messaging. See how Albato can help you enhance the app’s usability!

Connect Zendesk with Popular Apps | Streamline Your Support Workflow with Albato
4 min. read

Connect Zendesk with Popular Apps | Streamline Your Support Workflow with Albato

Zendesk offers a comprehensive customer service solution, designed for ease of use and scalability. See how Albato can help you enhance the app’s usability!

How to use Claude Artifacts: 7 Ways with examples | Guide 2025
Claude AI
10 min. read

How to use Claude Artifacts: 7 Ways with examples | Guide 2025

Learn how to use Claude Artifacts with our detailed guide. Explore 7 best ways with real Artifact examples: web pages, prototypes, presentations and visualizations.

Connect Gumlet with Your Favorite Apps | Optimize Your Media Management with Albato
3 min. read

Connect Gumlet with Your Favorite Apps | Optimize Your Media Management with Albato

Gumlet is best way to stream ad-free videos on internet. It has powerful CMS to organise videos and hollywood grade DRM. See how Albato can help you enhance the app’s usability!

Connect Octopush with Albato | Elevate Your SMS Marketing Strategy
3 min. read

Connect Octopush with Albato | Elevate Your SMS Marketing Strategy

With Octopush, businesses are well equipped to propel their brand, promote their offers and services at scale. See how Albato can help you enhance the app’s usability!