regexpExtract

regexpExtract (정규식 추출)

regexpExtract 함수는 제공된 정규식과 일치하는 값을 추출해요.

출처: 문서

본문

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

사용 예시

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

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

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

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

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

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

더 알아보기 (Learn more)

• 문자열 함수(String Functions)