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: Sean Hoppe on