PICK_OR_DEFAULT¶
Description¶
PICK_OR_DEFAULT takes an input value, a list of allowed values, and a default value.
If the input matches one of the allowed values (case-insensitive, whitespace-normalised), it returns the matched value
from the list.
Otherwise, it returns the default.
This is useful for normalising free-text input against a known set of options.
Example¶
If p.salutation is "mr", "MR", "Mr", or "mR", this returns "Mr".
If it does not match any option, it returns "Mx".