Special Regex > is match

Hello Everyone !

I try to find a formula to do this :

  • I have the entire text of an invoice
  • I would like to know if in this invoice there is the text : “05/2020 au ??/05/2020”. But I would like the question marks to be replaced any characters ! I would like a boolean variable True if the expression is in the invoice.

I tried to do this with a regular expression but I did not find …

Thank you for your help !!

(0|1)\d/\d{4}\sau\s.{2}/(0|1|2|3)\d/\d{4}

Hi @MatthieuRotaru

Have a look to the below Screenshot
image

regexr.com/57ogo

Hope this workflow may help you to solve your issue
Mark as solution if this helps you and like it :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Hello @Pratik_Wavhal and @Anthony_Humphries,

Thank you for your answers !! My exact solution was:
“(?<=(\d{2})(/05/2020 au ))(\d{2})(?=/05/2020)”

Thank you !

Hi @MatthieuRotaru

You are welcome :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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