purgechar, if not equal, not wildmatch? Which to use

[bobbydave]

Rate
BE-2014
0.11
AT-2016
UK-2016
1.11
1.21

I don't want to see BE-2014 or UK-2016 there are plenty more so I don't want to explicitly say if Rate <> AT....

Is there a way of say if(Rate <> ??-????, Rate)

I only want the Rate which would be something like 1.11 or 1 or 1.16

[bobbydave]

That got rid of them.

Only the decimal point rates are showing.

Thanks a lot.

This all works now

[Anil_Babu_Samineni]

Bobby,

Is this Value BE-2014 coming from Two fields na

Might be Country and Year as CountryYear. Here, You need to use CountryYear field only

[bobbydave]

From <> where IsNum(ApplyMap('MapCountryToEuro', Country &'-'&[Snapshot Year]));

and

where not WildMatch(ApplyMap('MapCountryToEuro', Country & '-' &  [Snapshot Year]), '**-****')
and  not WildMatch(ApplyMap('MapCountryToDollar', Country & '-' &  [Snapshot Year]), '**-****');

This resolved the issue. I only have the rates showing now.

Thanks to everyone for the assistance