Regexp search match multiple values

[#1]

Hi,

I am trying to match multiple values in a string using hive regxp, looking for an optimal solution.

I want to match "first" and "1.11" from the below

column name is col: 

This string is the first string with two decimals 1.11 and 2.22 with a special char / and some more extra string.

 table name is t:

query I was using:

 select * from t where t.col regexp '(?=.*first)(?=.*1.11)'

Could you please help me.

Thank you

[#2]

Regex always gives me a go.  Knowing if you have a typo, or are completely missing what works and what doesn't is always a big pain.   Try working with something like this Regex Tester to get your regex string setup:

https://regex101.com