# regexpExtract

Extracts values that match the provided regular expression

## Signature

> regexpExtract(value, regexp)
>
> regexpExtract(value, regexp, group)
>
> regexpExtract(value, regexp, group, defaultValue)

## Usage Examples

```sql
select regexpExtract('foo', '.*') AS value
from ignoreMe
```

| value |
| ----- |
| foo   |

```sql
select regexpExtract('foo123', '[0-9]+') AS value
from ignoreMe
```

| value |
| ----- |
| 123   |

```sql
select regexpExtract('foo123', '[^0-9]+') AS value
from ignoreMe
```

| value |
| ----- |
| foo   |

```sql
select regexpExtract('foo bar baz', '(\w+) (\w+)', 0) AS value
from ignoreMe
```

| value   |
| ------- |
| foo bar |

```sql
select regexpExtract('foo bar baz', '(\w+) (\w+)', 2) AS value
from ignoreMe
```

| value |
| ----- |
| bar   |

```sql
select regexpExtract('foo123', 'bar', 0, 'defaultValue') AS value
from ignoreMe
```

| value        |
| ------------ |
| defaultValue |