I wouldn't post a regex expression normally, but my expression works on <https://regex101.com/> but not within Snowflake.

I have values like `lastname, firstname`, `lastname, firstname middlename`, `last-name, firstname`, `last name, firstname`

and I need to extract just first name everytime.

My current expression is:  

`regexp_substr(name, '.*,(.*)( *| $)',1,1,'e')`  

I was hoping this would grab everything after the first name before either a line break or end. I also tried with \W instead of \b