I want to filter out strings that contain letters in my ETL.
e.g.
Serial
112233
445566PN
In the ETL
Add Formula
Column Name: IsInt
CASE
WHEN serial
LIKE ('%[A-Z]%') THEN 0
ELSE 1
END
EDIT
CASE
WHEN SERIAL
~* ([a-z]) THEN 0
ELSE 1
END
This is working for A-Z and is case insensitive.
Next question, is how do I filter out other characters?
Specifically, one serial number has a % sign in it, which is the wildcard symbol…