REGEXP_EXTRACT 字符串 以 AG 或 TS 开头，之后捕获所有内容

Question

下面是数据集示例，每一行都有以下值:


排
值(value)


1
AG3608-sueyfbnd-sjwfk

2
TS2649-sjwjmdaqo-wkdmfl

3
乌杰奥尔索普

4
sjhwu78iwjm


很快....
我想提取以 AG 或 TS 开头的值，然后捕获所有内容。下面是想要的结果


排
值(value)


1
AG3608-sueyfbnd-sjwfk

2
TS2649-sjwjmdaqo-wkdmfl


我写了这样的东西，但它只捕获了前两个字母 AG 或 TSregexp_extract(${column},'^(AG|TS).*')之后它不会捕获所有内容

Answer 1

使用捕获组和非捕获组:

regexp_extract(${column},'^((?:AG|TS).*)')

说明

--------------------------------------------------------------------------------
  ^                        the beginning of the string
--------------------------------------------------------------------------------
  (                        group and capture to \1:
--------------------------------------------------------------------------------
    (?:                      group, but do not capture:
--------------------------------------------------------------------------------
      AG                       'AG'
--------------------------------------------------------------------------------
     |                        OR
--------------------------------------------------------------------------------
      TS                       'TS'
--------------------------------------------------------------------------------
    )                        end of grouping
--------------------------------------------------------------------------------
    .*                       any character except \n (0 or more times
                             (matching the most amount possible))
--------------------------------------------------------------------------------
  )                        end of \1