Model

Discover Start Explore Model Integrate Engage

Discover Start Explore Model Integrate Engage

Accelerate the Value of Data

Model

Model Contents

Construct your data model

Transcode reference data

Cleanse data

Data validation function

Define Validation Function

Understanding the Expression Attribute

DVF string functions

Consolidate data

Manage profiles

Customize data tasks with LCAs

DVF string functions

Learn about string functions used in a data validation function.

Use string functions in Data Validation Functions to validate attributes that are composed of text or a combination of text and numeric characters.

Table 1. String Functions
Function	Description	Sample
`regexp`	The validation function checks that the given regular expression is matched. If the validation is met, then the appropriate validation message is displayed. This function supports the NOT conditional operator, and it works with empty values.	`regexp(attributes.DoB.value,'(0[1-9]\|1[012])[- /.](0[1-9]\|[12][0-9]\|3[01])[- /.](19\|20)[0-9]{2}')`
`equals`	The validation function checks that the attribute value exactly matches the given condition, ignoring the case. If the validation is met, then the appropriate validation message is displayed. This function supports the NOT conditional operator, and it works with empty values.	`equals(attributes.Status.value,'Active')`
`equalsCaseSensitive`	The validation function checks that the attribute value exactly matches the given condition, considering the case. If the validation is met, then the appropriate validation message is displayed. This function supports the NOT conditional operator, and it works with empty values.	`equalsCaseSensitive(attributes.Status.value,'Active')`
`contains`	The validation function checks that the attribute value contains the given value. If the validation is met, then the appropriate validation message is displayed. This function supports the NOT conditional operator, and it works with empty values.	`contains(attributes.FirstName.value,'Act')`
`containsWordStartingWith`	The validation function checks that the attribute value contains words starting with the given value. If the validation is met, then the appropriate validation message is displayed. This function supports the NOT conditional operator, and it works with empty values.	`containsWordStartsWith(attributes.Status.value,'Act')`
`startsWith`	The validation function checks that the attribute value starts with the given value. If the validation is met, then the appropriate validation message is displayed. This function supports the NOT conditional operator, and it works with empty values.	`startsWith(attributes.Status.value,'Act')`
`missing`	The validation function checks that the given value does not exist in the attribute value. If the validation is met, then the appropriate validation message is displayed.	`missing(attributes.Gender.value)`
`exists`	The validation function checks that the attribute value exists. If the validation is met, then the appropriate validation message is displayed.	`exists(attributes.Gender.value)`
`listEquals`	The validation function checks if the attribute value is in the given list. The elements of the list must be separated by commas. This function supports the NOT conditional operator, and it works with empty values.	`listEquals(attributes.Address.value,'100 Marine Pkwy #275, Redwood City, CA 94065, United States', '100 Marine Pkwy')`
`listEqualsCaseSensitive`	The validation function checks if the attribute value is in the given list. The search for the given value is case sensitive. The elements of the list must be separated by commas. This function supports the NOT conditional operator, and it works with empty values.	`listEqualsCaseSensitive(attributes.Address.value,'100 Marine Pkwy #275, Redwood City, CA 94065, United States', '100 Marine Pkwy')`
`fuzzy`	The validation function checks if the attribute value is similar to the given value. This permits minor differences between the query and the intended value. This function supports the NOT conditional operator, and it works with empty values.	`exists(attributes.Gender.value)`
`fullText`	The validation function checks if the attribute value is exactly the same as the given value. The search for the given value is case sensitive. This function supports the NOT conditional operator, and it works with empty values.	`fullText(attributes.Name.value,'Smith')`
`in`	The validation function checks that the attribute value exists in a list of static strings. If the validation is met then the appropriate validation message is displayed. This function supports the NOT conditional operator, and it works with empty values.	`in(attributes.Gender.value,'Male','Female')`

Updated on December 8, 2023

You've found your way to a temporary environment. Content is not complete or final. Looking for Reltio documentation? Go to docs.reltio.com.