EXTOL Business Integrator - How to test for null using Normalize

EXTOL Business Integrator - How to test for null using Normalize

TAGS: EXTOL Action / EXTOL Business Integrator / EXTOL EBI / EXTOL ruleset / EXTOL 2.5 /


One way to test for null values in a ruleset is to use NORMALIZE in an EXTOL EBI Action.

Test for null data:

  • Create EBI Conditional Expression Action
  • Statement: “Input normalize_space == value normalize_space”
  • Input and value are string inputs
  • In EBI ruleset, apply new EBI Action to Composite Rule
  • In first input field, apply String variable or String input
  • In second input input, enter a single space.

Test for existence of data data:

  • Create EBI Conditional Expression Action
  • Statement: “Input normalize_space != value normalize_space”
  • Input and value are string inputs
  • In EBI ruleset, apply new EBI Action to Composite Rule
  • In first input field, apply String variable or String input
  • In second input input, enter a single space.



Copyright 2012 @ www.seanhoppe.com


By: on

A free web counter provided by GoStats.