Data Tools

Text and Lists

Check, compare and normalise text values, strings and lists.

71 tools

View the tools catalog See all groups

What this group covers

Text tools validate and compare strings and lists: emptiness, case, numeric and alphabetic content, length, containment, sorting, uniqueness and equality. They make data quality rules explicit and repeatable without custom scripts.

When to use it

Reject blank or malformed required fields.
Enforce length and format rules at capture.
Check list uniqueness and order in imports.
Compare two text values consistently.

Text validation turns implicit data rules into explicit checks that every flow can reuse.

Tools in this group

Each tool shows its operation, description and cost. Browse the full catalog to search or filter.

List contains

This tool checks if a specific item is found within a list of values. You provide the list and the item to look for, and the tool tells you whether...

$1.00/1000

List ends with

Use this tool to check if a list of items ends with a specific value. You provide the list and the value you are looking for, and the tool tells yo...

$1.00/1000

Length list between

This tool checks if the number of items in your list falls between two specified numbers. It counts the items and compares them to your input limit...

$1.00/1000

Length list equal

This tool checks if the number of items in a list matches a specific quantity you provide. Common uses Verifying that a form submission contains ex...

$1.00/1000

Length list greater or equal

This tool checks whether the number of items in a list meets a specific minimum requirement. You provide a list of items and a target number, and t...

$1.00/1000

Length list greater

This tool checks if the number of items in a list is greater than a specific number you provide. The result is calculated immediately based on the ...

$1.00/1000

Length list lower or equal

This tool checks whether the number of items in your list is less than or equal to a specific number you provide. It compares the count of elements...

$1.00/1000

Length list lower

This tool checks if the number of items in a list is fewer than a specific number you provide. The result is always false if the list is empty or i...

$1.00/1000

Greater element

This tool checks if the highest number in a list matches the specific number you provide. It calculates the largest value from the items in your li...

$1.00/1000

Lower element

This tool checks whether the smallest value in a list of numbers matches a specific number you provide. The list must contain valid numbers separat...

$1.00/1000

List is sorted

This tool checks if a list of values is already arranged in ascending order. You provide a list, and the tool confirms whether the items follow the...

$1.00/1000

List starts with

This tool checks whether a specific text item is the very first element in a list. You provide a comma-separated list and a value to look for, and ...

$1.00/1000

Unique es list

Check whether all items in your list are different from each other. The tool looks at the values you provide and tells you if any of them appear mo...

$1.00/1000

Valid list

This tool checks if the text you provide is formatted correctly as a list of items. The check is purely structural and does not verify if the items...

$1.00/1000

Alphabetic string is valid

This tool checks whether a piece of text contains only letters from the alphabet (A-Z, a-z). It ignores spaces, numbers, symbols, and punctuation, ...

$1.00/1000

Alphanumeric string is

This tool checks whether the text you enter consists only of letters (a-z, A-Z) and numbers (0-9). It does not accept spaces, punctuation marks, or...

$1.00/1000

String is empty

This tool checks if a piece of text is completely empty, meaning it has no characters at all. Common uses Checking if a required text field was lef...

$1.00/1000

Boolean string is valid

This tool checks whether the text you provide is a valid yes/no indicator. It looks for the words 'true' or 'false' to confirm if the input is reco...

$1.00/1000

String contains char

This tool checks whether one piece of text appears inside another. You provide a main phrase and a short sequence of characters, and the platform t...

$1.00/1000

String ends with

This tool checks if one piece of text appears at the very end of another piece of text. You provide two inputs, and the platform tells you whether ...

$1.00/1000

IP has valid format

This tool checks whether the text you enter is a valid IP address. It accepts both IPv4 (like 192.168.1.1) and IPv6 (like 2001:0db8::1) formats. Th...

$1.00/1000

IPv4 has valid format

Checks whether the text you entered looks like a valid IPv4 address. It verifies the format only; it does not test if the address is actually activ...

$1.00/1000

IPv6 has valid format

This tool checks if an IPv6 address is written in a correct format. It verifies that the text follows the standard rules for this type of internet ...

$1.00/1000

String length is between

This tool checks whether the length of the text you provide falls within a specific range defined by two numbers. The length is measured in charact...

$1.00/1000

String length is equal

This tool checks if the number of characters in your text matches a specific length you provide. It is a simple validation step to ensure data entr...

$1.00/1000

String length is greater or equal

This tool checks whether the number of characters in your text is greater than or equal to the length you specify. Common uses Verify that a userna...

$1.00/1000

String length is greater

This tool checks whether the text you provide has more characters than a specific number you set. Common uses Validating that a username or passwor...

$1.00/1000

String length is lower or equal

This tool checks if a piece of text is short enough to meet a specific size limit. It compares the number of characters in your text against the ma...

$1.00/1000

String length is lower

This tool checks whether the length of the text you provide is shorter than the number you set as the limit. The result is calculated locally by co...

$1.00/1000

Text is lowercased

This tool checks whether the text you provide consists only of lowercase letters. It returns a simple yes or no result. Common uses Verifying that ...

$1.00/1000

Numeric string is valid

This tool checks whether a piece of text consists only of numbers. It is useful for filtering out unwanted text or symbols when you expect a numeri...

$1.00/1000

String is random

This tool checks whether a text string looks like random gibberish rather than meaningful language. It helps you spot data entry errors or fake inf...

$1.00/1000

String is valid by pattern

This tool checks whether a given piece of text contains a sequence of characters that matches a specific pattern you define. You provide the text t...

$1.00/1000

String starts with

This tool checks if one piece of text starts with specific characters found in another piece of text. The check is exact and case-sensitive, meanin...

$1.00/1000

Text is uppercased

This tool checks whether the text you provide consists entirely of uppercase letters. The result depends on the characters in the text. If the text...

$1.00/1000

Word count between

This tool checks if the number of words in a piece of text falls between two specific numbers. You provide the text and a minimum and maximum count...

$1.00/1000

Word count equal

This tool checks if the number of words in a sentence matches a specific number you provide. The count is calculated simply by looking at the text....

$1.00/1000

Word count greater or equal

This tool checks if the number of words in your text is greater than or equal to a specific number you provide. Common uses Verifying that a text e...

$1.00/1000

Word count greater

This tool checks if a piece of text contains more words than a number you specify. It counts the words in the text and compares that number to the ...

$1.00/1000

Word count lower or equal

This tool checks whether the number of words in a given sentence is less than or equal to a specific limit you provide. It counts the words in the ...

$1.00/1000

Word count lower

This tool checks whether the number of words in the provided text is less than a specified limit. The count is performed locally by the platform an...

$1.00/1000

Greater element

This tool finds the highest number in a list of values provided as a comma-separated text string. The tool converts the items in the list to number...

$1.00/1000

Lower element

This tool finds the smallest value in a list of items you provide. It works best with numbers, treating them as numeric values to find the lowest o...

$1.00/1000

Sorted list

This tool takes a list of items and arranges them in a specific order. It works best with a comma-separated list of text or numbers, such as '4,1,2...

$1.00/1000

Unique list

This tool takes a list of items and removes any duplicates, giving you a clean list where every item appears only once. The result is simply the or...

$1.00/1000

Sentiment from a text

This tool analyzes the emotional tone of English text, including emojis, to determine if the sentiment is positive, negative, or neutral. It calcul...

$1.50/1000

BASE64 value

This tool converts regular text into a Base64 encoded string. Base64 is a way to turn any text into a sequence of safe, standard characters that ca...

$1.00/1000

Formatted string by pattern

This tool takes a piece of text and a formatting pattern to create a new string. For example, you can use it to add zeros to the start of a number ...

$1.00/1000

Generated text by pattern

This tool creates a random sample of text that fits the pattern you describe. You provide a pattern using common text symbols, and the platform gen...

$1.00/1000

Field type by value

This tool looks at any piece of text you provide and tells you what kind of data it is. It checks the content against common patterns for things li...

$1.00/1000

HTML code from Markdown

This tool changes a text written in Markdown format into standard HTML code. Markdown is a simple way to write formatted text using plain character...

$1.00/1000

Merged values by text

This tool combines two pieces of text into a single result by placing a specific separator between them. The separator is applied exactly as you ty...

$1.00/1000

String length

This tool counts the number of characters in the text you provide. It is useful when you need to check the length of a name, message, or any other ...

$1.00/1000

Lowercased text

This tool converts all letters in the provided text to lowercase letters. Symbols, numbers, and other characters remain unchanged. Common uses Stan...

$1.00/1000

Markdown text from HTML

This tool changes HTML code into Markdown code. It takes HTML text and turns common elements like headings, paragraphs, bold text, links, and code ...

$1.00/1000

MD5 string

This tool creates a fixed-length code (hash) from the text you provide. It uses a standard method called MD5 to turn your input into a unique strin...

$1.00/1000

Normalized string by field

This tool cleans and formats text based on the type of information you provide, such as a name, address, or phone number. It removes unwanted chara...

$1.00/1000

Parsed text

This tool scans a block of text to find and extract common contact details like email addresses, phone numbers, postcodes, and web links. It simply...

$1.00/1000

Texts replaced by string

This tool changes specific text inside a message. You tell it what sentence to look at, what short phrase to find, and what new phrase to put in it...

$1.00/1000

Text replaced by string

This tool changes the first time a specific word or phrase appears in your text. You provide the original text, the part you want to find, and the ...

$1.00/1000

SHA string

This tool creates a unique digital fingerprint, known as a SHA-1 hash, from the text you provide. This process turns your input into a fixed string...

$1.00/1000

Spin string

This tool creates variations of your text by choosing random options from lists you define. It is designed to help you generate unique titles, blog...

$1.00/1000

Splitted values by separator

This tool takes a single piece of text and divides it into separate parts using a specific character or sequence you choose as the divider. The div...

$1.00/1000

Splitted and merged values by separator

This tool takes a piece of text and rearranges it by splitting it into parts and joining them back together using a new separator. Note that the bo...

$1.00/1000

Translated text

This tool changes the words in your text into a different language. You provide the original text and choose the language you want it translated in...

$2.00/1000

Uppercased text

This tool changes all the letters in the text you provide to uppercase. For example, 'Hi, Mike!' becomes 'HI, MIKE!'. Non-letter characters, such a...

$1.00/1000

String vLookup

This tool finds a matching text entry from a list of options based on the value you provide. It looks for an exact match or a similar match where t...

$1.00/1000

Text without HTML

This tool takes text that includes HTML formatting tags and extracts the plain text content. It removes the tags and converts special character cod...

$1.00/1000

Banned words

This tool scans the text you provide to find any English words that are commonly associated with spam emails. It helps you check your email content...

$1.00/1000

Text cleaned without abuse words

This tool removes known offensive or abusive words from your text. It checks the input against a fixed list of banned terms and replaces them with ...

$1.00/1000

Words count

This tool counts the total number of words in the text you provide. It looks for sequences of letters and numbers to determine the count. The resul...

$1.00/1000

View the full catalog

Apply these tools to your data

These tools are part of the Data Validation & Enrichment application. You can try them on your own records.

Try in the app See the application