delete line when 1 variable contains some specific signs

[PierreYvesILY]

hello,

I would like to delete the lines of a table, when the VAriable contains some specific chains of characters.

if NIEDERLASSUNGBEZ_BT contains ('GRM', 'CoC', 'NL MS') then delete;

how can I correct this?

thanks in advance

[Kurt_Bremser · Accepted solution]

Use the index() function:

if
  index(NIEDERLASSUNGBEZ_BT,'GRM') or
  index(NIEDERLASSUNGBEZ_BT,'CoC') or
  index(NIEDERLASSUNGBEZ_BT,'NL MS')
then delete;

or simplifiy this to a subsetting if:

if not (
  index(NIEDERLASSUNGBEZ_BT,'GRM') or
  index(NIEDERLASSUNGBEZ_BT,'CoC') or
  index(NIEDERLASSUNGBEZ_BT,'NL MS')
);

[PierreYvesILY]

thank you very much and have a nice day.

PY