Objectives

Reltio Products Developer resources Roles Applications Objectives

Reltio Products Developer resources Roles Applications Objectives

Unify and manage your data

Objectives

Objectives Contents

About objectives

Administer system

Model data

Manage reference data

Configure the Reltio UI

Load and export data

Stream data

Cleanse data

Data cleansing at a glance

Data cleansing operation

Define Data Validation Functions

Understanding the Expression Attribute

DVF string functions

Integrate data

Monitor data quality

Resolve potential matches

Manage profiles

Manage workflow tasks

Explore data insights

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 9, 2024

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

© 2024 The RELTIO® mark is a registered trademark of Reltio, Inc. in the United States and other countries; DataDriven and Reltio Data Cloud are trademarks of Reltio, Inc. Other names or marks are trademarks of their respective owners.

Terms, Privacy Policy, and