Text validations in CABAM help us identify and measure all the small text issues that users put into a database.
These can be issues like free format text not being used, illegal characters in a text, invalid IDs or incomplete texts. CABAM will identify and measure those issues, giving you a score as to how compliant that master data or that transaction data is.
In this function, we will show you how CABAM can use the Instring Check function to identify and measure a specific character at a specific position in a string of data. This is done to validate that specific characters are in a certain position in a string and to avoid logical applications relying on this […]
Here we demonstrate how CABAM can identify and measure all illegal characters in your free text fields. There is often finger trouble that slips into free text fields and has a negative knock-on effect in your system or reports, resulting in incorrect data and causing inefficiencies in the business. Let’s say – for example – […]
Here we will demonstrate how CABAM can identify and measure any phrases or words that should not be in specific fields (phrases like To Be Defined or Unknown). We also show how it could be used positively to validate that phrases exist in a field (such as an invoice number that should start in INV). […]
Here we will demonstrate how CABAM can be used to identify and measure the length of a field. Sometimes you don’t want certain fields to be too long or too short. Length Check can be useful in measuring this as well as identifying nulls in various fields. This is done to avoid missing data, interference […]
Here we will demonstrate how CABAM can be used to identify and measure certain records that don’t have all the fields populated or that is required for a complete record to exist. It ensures field completion by finding free text fields that use more characters than allowed or those that have a null that shouldn’t […]