Find word with regex

[CamiCat]

Hello friends,
I should find a certain word in a string.
In particular I should find the word "COMUNE" inside a string, for example inside "BONIFICO DA COMUNE"

How is it possible to implement the regex formula?
I should find the word COMUNE only if preceeded and succeeded by ".;,", not by numbers or letters.
Can you please help me in implementing this regex?
Thank you so much for your precious help,
Cami

 

[sheel]

Hi ,
Use Utility-String VBO , use regex from their
Thanks

 

[CamiCat]

Thank you so much @sheel.
Can you please share the regex expression that can be used to extract the word COMUNE only if preceeded and succeeded by ".;,", not by numbers or letters?
Thank you so much,
Cami

 

[sivagelli]

Using 'Test Regex Match' action from Utility Strings, helps in identifying if the regex pattern is present in the text string or not.

Input:

• Regex Pattern: "(COMUNE[,;])"
• Target String: "BONIFICO DA COMUNE DI BEDIZZOLE - YYY31072018 COMUNE DI BEDIZZOLE -SM- SM- DEL 31/07/2018 A A2A CICLO IDRICO S.P.A. P"

Output:

• Matched?

Output is a flag type, will return true is the target string has COMUNE, OR COMUNE; in it.

 

[CamiCat]

Thank you so so much @sivagelli.
Your help is always precious