If I want to eliminate all email prefixes that contain only numbers, is it somehow possible to write it in a code? For example, I have Email 12345@hotmail.com 34958409@hotmail.com I separate prefixes and get: Prefix 12345 34958409 Is it possible to declare in a code that if t1:Prefix = numeric, then exclude? I cannot assign numeric type to the whole variable, because it can also contain nominal values and its type is character. t1.Prefix IN ('1', '2', '3', '4', '5', '6', '7', '8', '9') doesn't work. Thanks.
... View more