remove data from a field

[#1]

Hi,

I'm new in QV and I can´t figure out how to remove data from a field..

My table is like this:

Product  Cost

A1           5

A2           4

A3           3

B            5

C           2

Basically I want to eliminate all the values on my fields "Product and Cost" that start with Product = A.

I guess is some kind of If o a function that removes a row..

Thank youuuuu

[Anonymous · Accepted solution]

If it is from file:

LOAD

Product,

Cost

FROM ...

where left(Product,1) <> 'A';

(There are other ways of course.)

[#3]

works prefectly!!!

[Clever_Anjos]

Or

LOAD

Product,

Cost

FROM ...

where Product not like  'A*';

[Anonymous]

I was wondering why so few answers

OK, one more:

...

where wildmatch(Product,'A*')=0;

[Clever_Anjos]

OR

where not wildmatch(Product,'A*');

[Anonymous]

Now we have a good number of solutions

[#8]

Lol yeah, I'll be a QlikView expert in removing data from fields soon haha