我在紅移表中有一個字串列，例如：
String
["0","0","5","0","0","0","0","0","0","0","0","0","0","0","0","0","0"]
["0","0","0","8","30","0","0","0","0"]
["0","0"]
我想拆分字串列以在 6 個不同的列中獲取字串的前 6 個字符，如下所示
| 細繩 | 第 1 列 | Col2 | 第 3 列 | Col4 | 第 5 列 | Col6 |
|---|---|---|---|---|---|---|
| ["0","0","5","10","20","30","0","0","0","0","0","0"," 0","0","0","0","0"] | 0 | 0 | 5 | 10 | 20 | 30 |
| ["0","0","0","8","30","0","0","0","0"] | 0 | 0 | 0 | 8 | 30 | 0 |
| [“0”，“0”] | 0 | 0 |
我是 Redshift 和正則運算式概念的新手。任何幫助都會有很大幫助。
uj5u.com熱心網友回復：
嘗試REGEXP_SUBSTR：
select
REGEXP_SUBSTR(mystr, '[0-9] ', 1, 1) as col1,
REGEXP_SUBSTR(mystr, '[0-9] ', 1, 2) as col2,
REGEXP_SUBSTR(mystr, '[0-9] ', 1, 3) as col3,
REGEXP_SUBSTR(mystr, '[0-9] ', 1, 4) as col4,
REGEXP_SUBSTR(mystr, '[0-9] ', 1, 5) as col5,
REGEXP_SUBSTR(mystr, '[0-9] ', 1, 6) as col6
from mytable;
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/355131.html
上一篇：為什么r_[r_]掛了？