Find a string into the values

Fri, 05 Oct 2012 16:06:00 GMT

Good afternoon,

I have a field which can take the values:

CAMB

CONT

DSTO

DSTO,CAMB

DSTO,PRC

DSTO,PRC,CAMB

ESTA

ESTA,DSTO

ESTA,DSTO,PRC

PRC

PRC,CAMB

UPGR

UPGR,DSTO

I would like to create a new field which resume that values in only four:

CAMB

CONT

DSTO

REST

For each value of the original field containing the string 'DSTO' the value of the new field must be DSTO, if not for each value containing 'CONT' the value of the new field must be 'CONT', if not idem with CAMB and the rest of casas must be REST.

I think I am looking for a commad how look for the string into the original field taking the values 'true' or 'false', combined with a chain of "if ...then"

What command or function I need to do this?

Thanks in advance.

Re: Find a string into the values

Gysbert_Wassenaar — Fri, 05 Oct 2012 16:14:00 GMT

Try this:

if(index(MyField,'DSTO'),'DSTO',if(index(MyField,'CONT'),'CONT',if(index(MyField,'CAMB'),'CAMB','REST')))

Re: Find a string into the values

Fri, 05 Oct 2012 19:37:05 GMT

Great thank you

topic Find a string into the values in QlikView

Find a string into the values

Re: Find a string into the values

Re: Find a string into the values