functions.sql

CREATE OR REPLACE FUNCTION dbl_excel_serial_date_to_date(x) AS (DATE '1900-01-01' + CAST(trunc(x) AS INTEGER));

CREATE OR REPLACE FUNCTION str_excel_serial_date_to_date(x) AS dbl_p_excel_serial_date(CAST(x AS DOUBLE));

CREATE OR REPLACE FUNCTION strip_for_match(a) AS LOWER(STRIP_ACCENTS(REGEXP_REPLACE(REGEXP_REPLACE(a, '&', 'and', 'g'), $$[-★|–#;@?´‛_“”ʻ‘’ʻ:"*/)('`+&.\s,\p{Cf}]$$, '', 'g')));