Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one Field Say
Number
R*14W
S43W*
ABCDE
EFGHI
i want output only ABCDE,EFGHI
Is this something you need in the script?
Also look here
Try this
WHERE NOT EXISTS ("*");
SQL SELECT .....;
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
];
LOAD F1 Where Index(F1,'*')=0;
LOAD * INLINE [
F1
R*14W
S43W*
ABCDE
EFGHI
];
Yes I want to show value only without * ,Using wildMatch Function in Script
Try like this
Table:
LOAD * INLINE [
Number
R*14W
S43W*
ABCDE
EFGHI
] Where Not WildMatch(Replace(Number, '*', '@'), '*@*');
it works but I still don't understand why using wildmatch() for that filter...
No idea... might be an interview question because there has been couple of request for the same scenario....