Checking Data Validity

[Muzeeb]

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

[AlexanderFillbrunn]

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