Combining LIKE and CONTAINS operator in SAP HANA

SAPSAP 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.

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