Special Regex > is match

[MatthieuRotaru]

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 !!

[Anthony_Humphries]

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

[Pratik_Wavhal]

Hi @MatthieuRotaru

Have a look to the below Screenshot

RegExr: Learn, Build, & Test RegEx

regex101: build, test, and debug regex

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

Happy Automation

Best Regards
Er Pratik Wavhal

[MatthieuRotaru]

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 !

[Pratik_Wavhal]

Hi @MatthieuRotaru

You are welcome

Happy Automation

Best Regards
Er Pratik Wavhal