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