Find the value by using wild match

[Anonymous]

Hi All,

Guys i want to show the value by using wild match,

The data is :

Table

A B C *

C D E *

G H I *

A N D D

D F R R

Value must be shoe where star value is not present by using wild match.

o/p

ANDD

DFRR

Thanks

[Anil_Babu_Samineni]

May be this?

If(Not SubStringCount(Table,'*'), Table) as Table

[sunny_talwar]

Looking to do something in the script?

[Anonymous]

Using wild match .

[sunny_talwar]

Have you tried loveisfail‌'s approach?

[Anonymous]

Yes, I got the answer it but condition is using wildmatch.

[sunny_talwar]

May be this

If(Not WildMatch(Replace(Table, '*', '@'), '*@*'), Table) as Table

[Anil_Babu_Samineni]

haha, Sunny Can we use combination of FindOneOf() with WildMatch(). I know your intention but this is awesome !!

[Kushal_Chawda]

But why you only need wildmatch?

[Anonymous]

Wild Match ()