Combining LIKE and CONTAINS operator in SAP HANA

The code you are using \1+ just removes consecutive occurrences only. You can use the below code.

SELECT REPLACE_REGEXPR('(.)(?=.*\1)' IN '22331122' WITH '' OCCURRENCE ALL)  FROM DUMMY

The output will come out to be “312”. This will remove all multiple occurrences and only last one will be kept.

Samual Sam

Published on 09-Feb-2018 11:26:29

• Related Questions & Answers
• What is the difference between –Match, -Like and –Contains Operator in PowerShell?
• Combining fields in CDS view in SAP ABAP
• How Are MySQL INSTR() and LIKE operator similar?
• Start and stop HANA system in SAP HANA Studio
• MongoDB: combining AND and OR?
• Learning SAP HANA and scope with ABAP-HANA or BI-HANA
• HANA Modeling objects and Content folder in SAP HANA Studio
• Learning SAP HANA Modeling and Administration
• Difference between SAP ERP and SAP S/4 HANA
• SAP HANA row and column store table
• SAP HANA Modeling Perspective in HANA Studio
• Customizing SAP HANA Perspective in HANA Studio
• SAP HANA database functions in HANA Cockpit
• De-normalization and Analytic views in SAP HANA
• Checking all tables and schema in SAP HANA