Wild Match ()

[madhavi_rajawat]

Hi,

I have one Field Say

Number

R*14W

S43W*

ABCDE

EFGHI

i want output only ABCDE,EFGHI

[sunny_talwar]

Is this something you need in the script?

[sunny_talwar]

Also look here

Find the value by using wild match

[zebhashmi]

Try this

WHERE NOT EXISTS ("*");

SQL SELECT .....;

[vishsaggi]

Or this? May be:

IF(FindOneOf(Number, '*') = 0, Number) AS NewNumber

LOAD *,

     IF(FindOneOf(Number, '*') < 1, Number) AS Values,

     FindOneOf(Number, '*') AS Num INLINE [

Number

R*14W

S43W*

ABCDE

EFGHI

];

[Anonymous]

LOAD F1 Where Index(F1,'*')=0;

LOAD * INLINE [

    F1

    R*14W

    S43W*

    ABCDE

    EFGHI

];

[madhavi_rajawat]

Yes I want to show   value only  without *  ,Using  wildMatch Function  in Script

[sunny_talwar]

Try like this

Table:

LOAD * INLINE [

    Number

    R*14W

    S43W*

    ABCDE

    EFGHI

] Where Not WildMatch(Replace(Number, '*', '@'), '*@*');

[Anonymous]

it works but I still don't understand why using wildmatch() for that filter...

[sunny_talwar]

No idea... might be an interview question because there has been couple of request for the same scenario....