How to select a substring up to a character in snowflake?

user_17771193 0
Viewed 284

My table in snowflake has a column with string values. 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 only get rid of either of one (comma or slash but not both) character.

Input values:

Compact SUV/Crossover
Luxury Subcompact SUV/Crossover
Subcompact Car,Sports Car
Luxury Car,Luxury Sports Car
Compact Car,Hybrid/Alternative Energy Car
Entrylevel Luxury Car
Midsize Car

Desired output :

Compact SUV
Luxury Subcompact SUV
Subcompact Car
Luxury Car
Compact Car
Entry level Luxury Car
Midsize Car
snowflake-schema snowflake-cloud-data-platform
1 Answers

A simple regex should help:

select regexp_substr(s, '^[^,/]*')
from (
  select 'Compact Car,Hybrid/Alternative Energy Car' s
)

enter image description here

user_1324380
Related