• V
    extractAllGroups(haystack, re_needle) function · 87b2d907
    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
FunctionsStringRegex.cpp 50.6 KB