How to exclude sth in straight table's demenision?

[#1]

Hello Everyone,

IF the datasource has several names in straight table:

AA

AB

CC

CD

BB

EE

How do I exclude the names with first letter "A"?

CC

CD

BB

EE

I only know that "like" can be used in the expression, such as like ‘A*’,but how to include 'A*'?

[bbi_mba_76 · Accepted solution]

Hi,

I don't know if I understand well, but you could use the wildmatch functions:

if(wildmatch(YourField,'A*')<1,YourField)

[#3]

Hi,

Like this

Table:

Load

YourField

From YourSource

Where WildMatch(YourField,'A*') <=0;

[anbu1984]

If(Left(Field,1) <> 'A',Field)

Or

If(Not(Field Like 'A*'),Field)

[#5]

thx a lot.

Problem Solved.