String values

Validations to check the format and length of string values in a column.

---

Strings length must be in range

Every value in the column must be a string with a length between the specified minimum and maximum. This validation is inclusive by default.

Use this when you want to enforce length constraints on a text column — for example, ensuring a country_code column always has between 2 and 3 characters, or that a description field is never empty or excessively long.

Parameters

Name	Type	Required	Description
Column	Column	✅	The column to validate.
Minimum value	Number	✅	The minimum allowed string length.
Maximum value	Number	✅	The maximum allowed string length.

Example

user_id	username
1	al
2	maria
3	this_username_is_way_too_long_for_our_system

	Example 1	Example 2
Column	username	username
Minimum value	3	2
Maximum value	20	50
Result	❌ Fails	✅ Passes
Reason	Row 1 has al (length 2), below the minimum of 3. Row 3 has a value exceeding the maximum of 20	All values have a length within [2, 50]

---

Strings length must be equal to

Every value in the column must be a string with exactly the specified length.

Use this when you need to enforce a fixed-length format — for example, a country_code column that must always be exactly 2 characters, or a product_sku that follows a fixed-length convention.

Parameters

Name	Type	Required	Description
Column	Column	✅	The column to validate.
Value	Number	✅	The exact required string length.

Example

transaction_id	country_code	currency
1	AR	ARS
2	USA	USD
3	BR	BRL

	Example 1	Example 2
Column	country_code	currency
Value	2	3
Result	❌ Fails	✅ Passes
Reason	Row 2 has USA (length 3), which is not equal to 2	All values in currency have exactly length 3

---

Column value must match regex expression

Every value in the column must match the specified regular expression.

Use this when you want to enforce a format pattern — for example, ensuring an email column always contains a valid email address, or that a phone column follows a specific format.

Parameters

Name	Type	Required	Description
Column	Column	✅	The column to validate.
Regex	String	✅	A regular expression that all values must match. For example: ^[A-Z]{2}$

Example

user_id	email
1	alice@example.com
2	not-an-email
3	bob@company.org

	Example 1	Example 2
Column	email	email
Regex	^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$	^.+$
Result	❌ Fails	✅ Passes
Reason	Row 2 has not-an-email, which does not match the email pattern	All values match the pattern — at least one character