Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I've a table like this (this is a fake one):
load*Inline
[column1, colunm2
axc, 1
ac,2
axd,3
azx,2
az,1
a,1];
How I can filter all the string on column1 that does not contain "x"?
I've tried so far the opposite, like:
load*Inline
[column1, colunm2
axc, 1
ac,2
axd,3
azx,2
az,1
a,1]
where column1 like '%x%';
But first it does the opposite that I want (I do not want the ones with the x), furthermore it does not work. Have you already done something like this before?
Thanks in advance
Hi simotrab, try this... in the load script.
where FindOneOf(column1,'x')=0;
Tell us if it's fine.
regards.
Try this:
WHERE NOT column1 LIKE '*x*';
First of all this works perfectly, thanks. Why it seems not working for "ac" for example (not important "a" and "c" , but "ac")?
It's work fine , with ..:
sampleTable:
load*Inline
[column1, colunm2
axc, 1
ac,2
axd,3
azx,2
az,1
a,1]
where not column1 like '*ac*';