EBIFour.com > Training > Clarify Tips > How-to Test a Value to Determine if Alpha or Numeric

How-to Test a Value to Determine if Alpha or Numeric

30th May 2020

By using the Cleo Clarify Matches condition, end-users are able to test values to determine if a value is completely numeric or if it contains alpha values.

Clarify Matches Condition

In the example below, we use the Clarify Matches condition we can use the RegEx pattern: ^\d+$ to determine if the value is numeric.

Cleo Clarify ruleset matches condition with RegEx screenshot


Applying Condition in Ruleset

In ruleset #51, we use the Clarify Matches Condition in the ruleset (below) to determine if the field custNum contains alpha values. If no alpha values are present them we execute ruleset #52 (populate JDEdwards F47011 SYSHAN field).

Cleo Clarify ruleset rules with match condition screenshot


By: on