0 the substring_index function in mysql returns the entire string if the substring isn't found or if the supplied occurrence is greater than the maximum occurrence Whenever a row had only one item (i.e My table in snowflake has a column with string values
ELLA ROSE 🥀 (@officialellarose) • Threads, Say more
The string has comma and slash
I need to list only the values before first comma or slash
I used snowflake split function, with that i could. Using regexp_substr in snowflake to extract digits asked 4 years, 4 months ago modified 4 years, 4 months ago viewed 12k times Extract everything between 2 strings in snowflake using regular expression asked 1 year, 8 months ago modified 1 year, 8 months ago viewed 1k times How to find a second/third occurrence in a string in snowflake/sql asked 5 years, 10 months ago modified 5 years, 10 months ago viewed 8k times
Snowflake string extract asked 2 years, 5 months ago modified 2 years, 4 months ago viewed 1k times Snowflake substring by pattern asked 5 years, 1 month ago modified 5 years, 1 month ago viewed 4k times