EBIFour.com > Training > Clarify Tips > What are Null Values in Cleo Clarify

What are Null Values in Cleo Clarify

9th July 2019

Based on the Cleo Clarify help text, the following are considered NULL

We will review valid null values and how to create logic around them

Null Types

EDI - A null value in EDI appears as ** (delimiterDelimiter).

Database - The default null value for null numeric fields is 0 (zero). The default null value for null alpha fields is either a single blank space ( ) or multiple blank spaces to length, depending on the field’s requirements.

Spreadsheet - The default null value for null fields is to leave the cell empty.

Flat File - Fixed Length - The default null value for string fields is a blank space ( ). The default null value for numeric fields is 0 (zero). Clarify fills the entire length of the field with the null value. For example, a numeric field with a length of five will display a null as 00000.

Flat File - Delimited - The null field appears as ,, (delimiterDelimiter). If a field has a minimum length and is null, the field will be padded with empty characters (leading zeros for numeric, trailing spaces for alpha).

XML - A null value appears as <tag/> with tag being the specific tag for the empty attribute.

How to Handle Null Values

In a previous post, we discussed Clarify V2 Ruleset Conditions- IsNotNullorWhiteSpaces - IsNullorWhiteSpaces .

This post shows how to easily test or the existence of nulls.


By: on