Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Try this:
Where not(WildMatch(Key,'*
Thanks Jaume, but this would eliminate
You can try like:
Where not FindOneOf(Key, 'ABCGHIJKLMNOPQRSTUVWXYZ'); // excluding DEF
Thanks Tresesco, but A,B,C.. what I mentioned would not actually be alphabets in my data. Also, I won't know these data as these would change frequently. What I have is the values/combinations that need to be excluded (the values would be large though)
Taking these into consideration, the FindOneOf logic won't work.
You might have to include other possible characters as well in the findoneof() like:
Where not FindOneOf(Key, 'ABCGHIJKLMNOPQRSTUVWXYZ!@#$%abcd...'); // excluding DEF
What about brute force?
Where not(WildMatch(Key,
Whit only 3 keys (as in your problem) you can do it in a finite time and it should work (not beautiful but works).
I'll let you know if I find a better way to do it.
Jaime.
If you need more dynamic solution, you might have to try something like explained here:
Hi Tresesco,
This does not work as expected. I want to exclude all combinations that can be formed from 'D','E','F' {D,E,F,DE,ED,EF,FE,DF,FD,DEF,DFE,EDF,EFD,FDE,FED}
Though actual data would be large enough.
where not match(Key,