从string sql netezza中提取字符串
从string sql netezza中提取字符串
提问于 2020-01-08 16:10:33
请给我一个列，包括一个字符串，如下所示
Plan
{"en_US":"Ultra 2 Speed Up to 100Mbps Prepaid FTTH(140GB)","ar_EG":"Ultra 2 Speed Up to 100Mbps Prepaid FTTH(140GB)"}
{"en_US":"Ultra 2 Speed Up to 100Mbps Prepaid FTTH(600GB)","ar_EG":"Ultra 2 Speed Up to 100Mbps Prepaid FTTH(600GB)"}
{"en_US":"Super 3 speed Up to 30Mbps Prepaid FTTH(250GB)","ar_EG":"Super 3 speed Up to 30Mbps Prepaid FTTH(250GB)"}
{"en_US":"Ultra 2 Speed Up to 100Mbps Prepaid FTTH(250GB)","ar_EG":"Ultra 2 Speed Up to 100Mbps Prepaid FTTH(250GB)"}我需要将字符串提取到三个字段中
第一个像下面这样
Rate_Plan
Ultra 2 Speed Up to 100Mbps Prepaid FTTH(140GB)
Ultra 2 Speed Up to 100Mbps Prepaid FTTH(600GB)
Super 3 speed Up to 30Mbps Prepaid FTTH(250GB)
Ultra 2 Speed Up to 100Mbps Prepaid FTTH(250GB)第二个像下面这样
Quota
140
600
250
2503ed字段如下所示
Speed
100
100
30
100回答 1
Stack Overflow用户
回答已采纳
发布于 2020-01-09 07:23:25
读取regexp_extract()函数：https://dwgeek.com/netezza-regular-expression-functions-examples.html/
在您的示例中，从‘^(^：)：(^：)：.$’开始，然后提取模式号2，然后使用类似的方法从该字符串中提取另外两个字符串：‘^。到(0-9)+Mbps‘(模式1)
我希望你能跟上。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/59649782
复制相关文章
相似问题
腾讯云开发者
