Remove rows that contain "C0"?

[krithikarees]

Hello,

I am trying to figure out how to remove all rows of customer number that starts with "C0". Where customer Number is my Key Joining field with other tables.

I need them gone

[isingh30]

You need solution at script level or UI level?

[jwjackso]

In the where clause try Mid(Text([Customer Number]),1,1) <> 'C'

[Chanty4u]

try this

Load*

from table where wildmatch(Field,'*c*')<>1

[krithikarees]

UI level would be great.

Thanks

[OmarBenSalem]

in your measure:

do as follow:

sum({<CustomerNumber=-{"CO*"}>}YourMeasure)

[Chanty4u]

try this

add in UI:

=count({<CusstNum-={"CO *"}>} Number)

[qv_testing · Accepted solution]

Try this,

=IF(wildmatch(CURRENCY,'*CO')<>1, CURRENCY)