Split string into elements of a row section (array)
How the tool works (not for users)
Instructions for CIS
How does this tool work?
Like other Albato tools, it is added between steps of an automation. To do this, click on the "+" and select the tool from the list.
The tool has two required fields:
String to split - specify a field from the previous steps to split.
Delimiter - specify a symbol to divide the string into elements. Any symbol/set of symbols can be used as a delimiter.
As a result of the tool, a user receives a row section - "Split elements" - in the next step of the automation.
This section has one field that will contain these elements.
Below is a visualization of the tool's operation:
(We will show you how this tool works below)
string = “name1;name2;name3”; // we get a string with several elements;
[
{result: ‘name1’},
{result: ‘name2’},
{result: ‘name3’},
]
// we display the result as three strings in one section.
How the result of the tool will look:
All ";" symbols will divide the incoming string into the elements of a row section.
In the example of spreadsheets, the result will be either three lines in one cell or three rows separately.
Updated on: 04/05/2023
Thank you!