The Text operators section offers a suite of blocks designed to manipulate and transform text data within your workbook. These tools provide essential capabilities for handling strings, enabling you to modify text inputs dynamically to suit your application's needs. From basic transformations like concatenation and trimming to more complex operations such as regex matching and substring extraction, each block is built to offer specific text manipulation functionalities. Below, each block is described in detail to help you understand its functionality and use cases, empowering you to effectively manage and utilize text data in your projects.

This block transforms text input into a numerical value, adhering to the decimal and thousand separators specified in the Data View locale settings. It efficiently handles the conversion of percentage figures as well.

Configuration

Outputs: Number - The numerical representation of the input text.

Supports

This block combines two text inputs into a single text output. It allows users to merge text values from various sources, incorporate custom separators, and create well-formatted text combinations suitable for reports or data storytelling.

Configuration

Outputs: Text - The combined result of Text01 and Text02.

Supports

This block combines multiple text inputs into a single text output. It allows users to merge text values from various sources, incorporate custom separators, and create well-formatted text combinations suitable for reports or data storytelling.

Configuration

Use the plus sign to add text inputs. Use the minus sign to remove a text input.

Outputs: Text - The combined result of the text inputs.

Supports

This block transforms text input into a specific case format based on the selected option, making it suitable for formatting textual data consistently. It does not alter numerical values or special characters but adjusts the letter case as specified.

Configuration

Outputs: Text - The text converted to the specified case format (either upper-, lower-, or title case).

Supports

This block replaces occurrences of a specified substring within the given text with a new substring. Ideal for data cleaning, standardisation, and content transformation tasks without requiring complex coding.

Configuration

Outputs: Text - a string after replacing all occurrences of a given substring within the input string with another substring. The function is non-recursive and works from left to right.

Supports

This block reverses the characters in the given text.

Configuration

Outputs: Text - The text in reverse order.

Supports

This block trims spaces from the specified part of the text, which can be from the left, right, or both sides of the text string.

Configuration

Outputs: Text - The trimmed text.

Supports

This block extracts a substring from a specified text based on user-defined start and end points. Ideal for text manipulation tasks such as data extraction and content formatting, this block simplifies complex string operations without requiring in-depth coding. Users can define the start and end positions in multiple ways, whether from the beginning, the end, or relative to another position within the text.

Configuration

Outputs: Text - The substring extracted from the start to the end positions specified.

Supports

This block splits a string of text into an array of substrings using a specified delimiter. It then retrieves a segment based on the provided index, allowing for easy and flexible extraction of specific parts of the string. Ideal for parsing structured text formats like CSV or log files, this block simplifies data extraction tasks.

Configuration

Outputs: Text - The segment of the text at the specified index.

Supports

This block retrieves a specific letter from a given text based on the specified index. It is particularly useful for extracting characters from strings where each character’s position is significant, such as in data parsing, initial letter analysis, or when processing formatted codes. This tool facilitates quick and precise character extraction without the need for loops or complex string operations.

Configuration

Outputs: Text - The single character at the specified position in the text.

Supports

This block calculates the total number of characters in a given text. It is useful for determining the length of strings in various contexts, such as validating input data, sizing fields in user interfaces, or performing text analysis tasks. This simple yet essential function aids in managing text data by providing immediate measurements of text lengths.

Configuration

Outputs: Number - he number of characters in the provided text, including spaces and punctuation.

Supports

This block counts the number of times a specific substring appears within a given string of text. It is particularly useful for text analysis, such as frequency analysis in data processing or validating content for specific character requirements. This tool offers a straightforward approach to quantifying character occurrences, enhancing data validation and analytical tasks.

Configuration

Outputs: Number - The total count of the specified substring (case sensitive) in the provided text.

Supports

This block transforms text input into a numerical value, adhering to the decimal and thousand separators specified in the Data View locale settings. It efficiently handles the conversion of percentage figures as well.

Configuration

Outputs: Boolean - Returns True if the main text contains the substring, otherwise False.

Supports

This block tests whether a given text matches a specified regular expression (regex) pattern. It is highly useful for validating inputs, searching for patterns, and processing text based on specific criteria. This function is vital for ensuring data integrity and compliance with formatting standards in user inputs and data processing.

Configuration

Outputs: Boolean - Returns True if the text matches the regex pattern, otherwise False.

Supports