Use WildMatch or LIKE to only show values without an *

[YellowStone]

Hi, 

I have a list of countries and regions, for example:

Western Sahara*

China

Saudi Arabia

Tibet*

Regions are indicated with an * after the name.

In one of my tables I want to display countries only so only display the values without an *.

Usually I do this by using a function in the expression editor of the field:

=If(NOT WildMatch(Field, '*'), Field)

or

=If(NOT Field LIKE '*', Field)

However since * is used as a wildcard in these functions. I have difficulties applying one of these functions to my particular example.

If possible I don't want to create an additional variable/column in the data that says Country/Region.

Any ideas?

Thanks!

[marcus_sommer · Accepted solution]

Try it with replacing the wildmatch() with index().

- Marcus

[YellowStone]

Thank you Marcus, does the job indeed.