I have a column is event\_list. So I would like to extract the number after `20220=`. The value would contain `.`, but i could only get the value before `.`. 

My current query is 

```
regexp_extract(event_list, '20220=([0-9]+)', 1)

```

The event\_list column is like
[![enter image description here](https://i.stack.imgur.com/NcoT6.jpg)](https://i.stack.imgur.com/NcoT6.jpg)