In Cleo Clarify Rulesets (Version 2), users are able to create Methods to repeat logic multiple times, but only code once for it.

In our example below we have a Clarify Ruleset that we need to remove control characters that might cause problems when we import the data, into our database

In our example we will use the Clarify ReplaceAll task to remove the following characters

unicode - decimal - description
\u0009 - 09 - horizontal tab
\u0011 - 17 - device control 1
\u0026 - 38 - ampersand
\u00a0 - 0160 - non breaking space
\u00c2 - 0194 - Latin Capital letter A with circumflex
\u00bf - 0191 - Inverted Question Mark
\u00ae - 0174 - Registered sign
\u0021 - 33 - Exclamation mark
\u002a - 42 - Asterisk
\u003c - 60 - Less-than sign
\u003e - 62 - Greater-than sign
\u002c - 44 - Comma
\u003f - 63 - Question mark

STEP 1: Set-up Ruleset Rules

In our ruleset, we will create 2 variables

• vInput
• vOutput

With these 2 Ruleset variables we perform the following:

• pass our alpha data into vInput
• Call textClean
• pass vOutput to the Target field: ItemDescription
  

STEP 2: Calling the Ruleset Method

In our ruleset screenshot (above), we are calling the method. In the exampple, we will be calling the Parent record group.

When we originally set-up the Ruleset Method, we defined the Record Group, as the trigger for the method.

STEP 3: Method Access

To create/access the Ruleset Method, we will choose the Methods tab.

STEP 4: Create/Access Method

The Ruleset Method can be created below.

When creating the Ruleset Method, we will need to define a trigger. In our example we used the parent record group

STEP 5: Ruleset Method Rules

Once we access the Ruleset Method

STEP 6: ReplaceAll Rule

In the ReplaceAll Ruleset rule, we pass-in the vInput variable (from Step 1) and output the resultant to the vOutput variable (from Step 2).

In Conclusion:

The Cleo Clarify Ruleset Method can look intimidating, and nuanced, at 1st, however they can be a great time-saver when implemented.

Our team at the Sean Hoppe Consulting Group, can assist end-users with setting up their implementation.