使用正则表达式分割复杂的字符串 [英] Splitting complex string using Regular Expression

问题描述

我有这个字符串，我需要使用Oracle Regexp_substr

I have this string which i need to split using Oracle Regexp_substr

字符串就像

"123456","4,5,6","Hi This is "Sample" String",12345,022222

我需要将此字符串拆分为

I need to split this string as

"123456"
"4,5,6"
"Hi This is "Sample" String"
12345
022222

我尝试使用以下逻辑尝试使用",作为分隔符，然后使用,作为分隔符提取字符串，当我使用REGEXP_(string,'".*",',1,1)时将bur提取出来，然后将字符串变成

I tried using the following logic Tried to extract string using ", as delimiter followed by , as delimiter, bur when I use REGEXP_(string,'".*",',1,1) then it turns the string into

"123456","4,5,6","Hi This is "Sample" String",

因为REGEXP是贪婪的表情.

since REGEXP are greedy expression.

我如何达到最终结果?

推荐答案

此示例适用于您的示例:

This one works for your examples:

(".+?"(?=,))|\w+

这篇关于使用正则表达式分割复杂的字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！