Examples of RegexpReplaceFunction

com.salesforce.phoenix.expression.function.RegexpReplaceFunction

Function similar to the regexp_replace function in Postgres, which is used to pattern match a segment of the string. Usage: REGEXP_REPLACE(,,) source_char is the string in which we want to perform string replacement. pattern is a Java compatible regular expression string, and we replace all the matching part with replace_string. The first 2 arguments are required and are {@link com.salesforce.phoenix.schema.PDataType#VARCHAR}, the replace_string is default to empty string. The function returns a {@link com.salesforce.phoenix.schema.PDataType#VARCHAR} @author zhuang @since 0.1

org.apache.phoenix.expression.function.RegexpReplaceFunction

Function similar to the regexp_replace function in Postgres, which is used to pattern match a segment of the string. Usage: REGEXP_REPLACE(,,) source_char is the string in which we want to perform string replacement. pattern is a Java compatible regular expression string, and we replace all the matching part with replace_string. The first 2 arguments are required and are {@link org.apache.phoenix.schema.PDataType#VARCHAR}, the replace_string is default to empty string. The function returns a {@link org.apache.phoenix.schema.PDataType#VARCHAR} @since 0.1

    }
    
    @Test
    public void regexpReplace() throws Exception {
        List<Expression> args = Lists.newArrayList(getInvertedLiteral("blah", PDataType.CHAR), getLiteral("l.h"), getLiteral("foo"));
        evaluateAndAssertResult(new RegexpReplaceFunction(args), "bfoo");
    }

    }
    
    @Test
    public void regexpReplace() throws Exception {
        List<Expression> args = Lists.newArrayList(getInvertedLiteral("blah", PDataType.CHAR), getLiteral("l.h"), getLiteral("foo"));
        evaluateAndAssertResult(new RegexpReplaceFunction(args), "bfoo");
    }

    }
    
    @Test
    public void regexpReplace() throws Exception {
        List<Expression> args = Lists.newArrayList(getInvertedLiteral("blah", PDataType.CHAR), getLiteral("l.h"), getLiteral("foo"));
        evaluateAndAssertResult(new RegexpReplaceFunction(args), "bfoo");
    }

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of RegexpReplaceFunction

Examples of com.salesforce.phoenix.expression.function.RegexpReplaceFunction

Examples of org.apache.phoenix.expression.function.RegexpReplaceFunction

Examples of org.apache.phoenix.expression.function.RegexpReplaceFunction