Find a string into the values

[#1]

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.

[Gysbert_Wassenaar · Accepted solution]

Try this:

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

[#3]

Great thank you