Exclude Wrong Format

Hi,
in my flow i have a column with date-time form.
I need to exclude wrong format (I found some cell with “later I’ll put” or “2nd” etc.).
My format is dd/MM/yyyy H.mm.ss.
What node i could use?

Hello @pollyste

‘Rule Engine’ node:

$date$ MATCHES "^\d+[\/]\d+[\/].*" => TRUE
TRUE => FALSE

BR

1 Like

Thanks, it’s ok. A question where i could find syntax rules between " " for a string that you used if i desire create another rule?

REGEX takes some time to get used to.

You can practice and test your syntax in https://regex101.com/
You can find all the syntax information + explanation to your testing in the right hand side.

You can start by searching in google for your use case, there are some Q&A literature in websites like https://stackoverflow.com/

Besides, you can need different syntax depending on the node and function that you are using. There are few highly skilled knimers in forum to help in this part.

BR

5 Likes

Be particular aware of the string manipulation node with regex. I always tend to forget the “backslash hell” there
br

1 Like

@pollyste

Syntax explanation:

This was a very fast format matching :upside_down_face:, it can be improved if needed

BR

2 Likes