You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Nikita Pande (Jira)" <ji...@apache.org> on 2024/02/08 07:41:00 UTC
[jira] [Updated] (PHOENIX-7202) Support STRIP operators as built in functions
[ https://issues.apache.org/jira/browse/PHOENIX-7202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nikita Pande updated PHOENIX-7202:
----------------------------------
Description:
STRIP: [https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-strip]
{*}Description{*}: The STRIP function removes blanks or another specified character from
the end, the beginning, or both ends of a string expression.
{*}Example{*}: Remove a specific character from a string, o/p is *Hello World *
{code:java}
SELECT STRIP('---Hello World---', B, '-') AS StrippedString FROM SYSIBM.SYSDUMMY1;
{code}
> Support STRIP operators as built in functions
> ---------------------------------------------
>
> Key: PHOENIX-7202
> URL: https://issues.apache.org/jira/browse/PHOENIX-7202
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Nikita Pande
> Priority: Major
>
> STRIP: [https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-strip]
> {*}Description{*}: The STRIP function removes blanks or another specified character from
> the end, the beginning, or both ends of a string expression.
> {*}Example{*}: Remove a specific character from a string, o/p is *Hello World *
> {code:java}
> SELECT STRIP('---Hello World---', B, '-') AS StrippedString FROM SYSIBM.SYSDUMMY1;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)