How to choose the right match

Hello everyone

How to choose the right match?

Text:

Park Avenue 1 que

need to choose the right match:

AUP_Park_avenue_2que

AUP_Park_avenue_1q        <---------

AUP_Park_avenue 3

AUP Park avenue 4

tried using macthes but failed :neutral_face:

Use regular expression AUP_Park_avenue_1q.

The fact is that this value is always different, but of this format

Therefore, the method you described is not suitable for me

Maybe try like this (with case insensitive option):
((Park).*(Avenue).*(1))

if the word is in a variable?

Just construct your expression as a String variable.

the word is a string variable and it is always different

https://docs.microsoft.com/en-us/dotnet/visual-basic/language-reference/keywords/string-manipulation-summary

1 Like

can you give an example please?