-
由 Vasily Nemkov 提交于
Function that extracts from haystack all matching non-overlapping groups with regular expressions, and put those into Array(Array(String)) column. Example: :) SELECT extractAllGroups('abc=111, def=222, "jkl mno"="444 foo bar"', '("[^"]+"|\\w+)=("[^"]+"|\\w+)'); ┌─extractAllGroups('abc=111, def=222, "jkl mno"="444 foo bar"', '("[^"]+"|\\w+)=("[^"]+"|\\w+)')─┐ │ [['abc','def','"jkl mno"'],['111','222','"444 foo bar"']] │ └────────────────────────────────────────────────────────────────────────────────────────────────┘
87b2d907