Table Filter Options

[#1]

Hello, I'm a Newby so i'm hoping anybody could tell me how too do this..

I've created a table like this:

LOAD*INLINE [
COBRA Table1
Z00001
Z00002
Z00003
ZNIET1
20
Z00004
];

This works fine, but i wonder if there is anyway that i can Filter "20" / "ZNIET1" out of this table. Or to show only the "Z00001" / "Z00002" / "Z00003" / "Z00004" values.

( this is a small example the normal lists contains more rubbish, I'd like to have only the Z00001 / Z00002 / Z00003 / Z00004 values left ).

Thanks!

Mark

[#2 · Accepted solution]

Useee the power of w�ldmatch .. 🙂

best regards

COBRATable1:
LOAD * WHERE WILDMATCH([COBRA Table1],'Z0*');
LOAD*INLINE [
COBRA Table1
Z00001
Z00002
Z00003
ZNIET1
20
Z00004
];

[#3]

Thanks! Works great!

[#4]

Thanks! Works great!