COPY INTO Optimization – Listing External Files
I am trying to optimize my COPY INTO command.
regular expression with regexp_like is not working in snowflake
SELECT ‘HAB’ AS NAME, CASE WHEN REGEXP_LIKE(LIST_TXT, ‘(^|,)201(,|$)’) THEN ‘YES’ END AS MC_NM FROM TABLE1 ) SELECT * FROM HAB; my reg expression works as expected outside of Snowflake, but it gives me null for MC_NM even though there is LIST_TXT with 201 in it. sql regex snowflake-cloud-data-platform
In Snowflake, with REGEXP_SUBSTR, how do you extract the date from a string with M/D/YYYY, M/DD/YYYY, MM/DD/YYYY or MM/DD/YYYY formats?
In Snowflake, with REGEXP_SUBSTR, how do you extract the date from a string with M/D/YYYY, M/DD/YYYY, MM/DD/YYYY, MM/DD/YYYY formats?