Magic ETL doing regex_like: making a text column numeric and all non numeric values set to -1
Hi all, I am looking to transform data in Domo which is a mix of numbers and alphabet characters and am trying to create a new column using an operation similar to Oracle's regex_like function and a case statement. I can do this in SQL, but would like to know if Magic ETL can do something similar. With the example below,…