Originally posted by DBlank Does this field alwasy have "/" once in it?
if left({AO.MOT},4) <> "MEK/" then {AO.MOT} else
if split({AO.MOT},"/")[2] in ["DAGREP","POOL"] then {AO.MOT} else 'MEK'
I think there is something wrong with the data in POOL, I tried with another and that worked perfectly, like this:
if {AO.MOT} = ["MEK/DAGREP","PLAT/SVETS"] then {AO.MOT} else
IF instr({AO.MOT},"/")>0 THEN
left({AO.MOT},instr({AO.MOT},"/")-1)
ELSE
{AO.MOT}
If I switch PLAT/SVETS to MEK/POOL it shows only MEK
Thank you for your efforts...