You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by gr...@apache.org on 2014/11/13 19:58:55 UTC

svn commit: r1639446 - /phoenix/phoenix-docs/src/docsrc/help/phoenix.csv

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","