Checking Data Validity

Hi,

  1. How to check if the data only contains valid printable characters in the character, numeric, or date fields?
    Note : my data ASCII format

Please find the attached screenshot for your reference.

Regards,

Muzeeb

Hi Muzeeb,
For that you can use the Rule Engine node with the MATCHES operator. It checks the input against a regular expression. A simple rule could be:

$prodno$ MATCHES "^[0-9a-zA-Z]+$" => "ok"
TRUE => "not ok"

This only allows numbers and letters in a column. You can use regex101.com to test your regular expression on different inputs.
Kind regards,
Alexander

2 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.