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?
‘Rule Engine’ node:
$date$ MATCHES "^\d+[\/]\d+[\/].*" => TRUE TRUE => FALSE
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.
Be particular aware of the string manipulation node with regex. I always tend to forget the “backslash hell” there
This was a very fast format matching , it can be improved if needed