I have a list of value that are allowed such as: the cat, the mouse, the dog, and the parrot. Now I want to have the possibility to add many values from this list in a cell separated with semicolon (;).
That means I can add:
The cat; The dog; The mouse
The cat; the parrot
The mouse; The cat
The parrot
But I can not add
The lion; the cat
The mouse; the parrot; the Lion
The cat;( That means I can not add a semicolon at the end)
The cat; The mouse;
;( That means i can not just add a semi colon) I try to write a constraint using this function regexp_like but this does not work fine.
not REGEXP_LIKE (animal, '[^(the cat| the mouse |the dog|the parrot|; )]', 'i')
N.B: animal is the column which I applied the constraint