Select in field values like *

[lfalmoguera]

Hi all,

I´ve looking in other post the way to do this, but has not find anything yet.

Is there any way to perform the Action --> Select in Field

And within the string box select all values which are "like "String*".

I have so many Strings and want to avoid to populate all them using the (String1|String2|...|StringN).

Furthermore, the names of the Strings may change, so I need to avoid populating all of them!

Thanks a lot in advance!

[Miguel_Angel_Baeyens]

Hello,

You can use wildcards in the value of the field, so

String*

Will select in the field all values starting with "String".

Is that what you are looking for?

[lfalmoguera]

Thanks!

But the problem is that I have "empty spaces" within the strings.

For instance, imagine I have:

Calle Alcala

Avenida Alcala

Calle Gran Via

What do I write in the box to select those two with "Alcala" string?

[Anonymous]

Empty spaces don't matter.
What matters is that in your example you need * in the beginning as well:
*String*

[lfalmoguera · Accepted solution]

I DO need to take a rest : P

[Miguel_Angel_Baeyens]

Hi,

Using wildcars in both left and right will return empty spaces, starting with, ending with...

*Alcala*

Hope that helps.

[lfalmoguera]

Thanks a lot!

What about a not like?

[Miguel_Angel_Baeyens]

Use two actions:

1.- Select in field *Alcala*

2.- Then Select Excluded using that field

Hope that helps

[lfalmoguera]

Fantastic!