Author: greid Date: Thu Nov 13 18:58:55 2014 New Revision: 1639446 URL: http://svn.apache.org/r1639446 Log: PHOENIX-1256 Updated docs for REGEXP_SPLIT
Modified: phoenix/phoenix-docs/src/docsrc/help/phoenix.csv Modified: phoenix/phoenix-docs/src/docsrc/help/phoenix.csv URL: http://svn.apache.org/viewvc/phoenix/phoenix-docs/src/docsrc/help/phoenix.csv?rev=1639446&r1=1639445&r2=1639446&view=diff ============================================================================== --- phoenix/phoenix-docs/src/docsrc/help/phoenix.csv (original) +++ phoenix/phoenix-docs/src/docsrc/help/phoenix.csv Thu Nov 13 18:58:55 2014 @@ -1403,12 +1403,14 @@ REGEXP_REPLACE('abc123ABC', '[0-9]+', '# " "Functions (String)","REGEXP_SPLIT"," -REGEXP_SPLIT( stringTerm, patternString ) +REGEXP_SPLIT( stringTerm, patternTerm ) "," -Returns a VARCHAR array by splitting the stringTerm based on the Java compatible regular -expression patternString. +Splits a string into a VARCHAR ARRAY using a regular expression. +If characters that have a special meaning in regular expressions are to be used +as a regular delimiter in the pattern string, they must be escaped with backslashes. "," -REGEXP_SPLIT('one,two,three', ',') evaluates to ['one','two','three'] +REGEXP_SPLIT('ONE,TWO,THREE', ',') evaluates to ARRAY['ONE', 'TWO', 'THREE'] +REGEXP_SPLIT('ONE!#TWO#,!THREE', '[,!#]+') evaluates to ARRAY['ONE', 'TWO', 'THREE'] " "Functions (General)","MD5","