DB2 to HANA Migration -DB2 Translate () function achivement in SAP HANA
DB2 to SAP HANA Migration -Db2 Translate () function in SAP HANA
DB2 Query :
select PHONE_NUMBER,
(TRANSLATE(PHONE_NUMBER,”,‘1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz()-/’)) as PHNE
from “Phone_test“
In above query where ever its find any letter from this string ‘1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz()-/’ in phone number It replace with Space like ‘ ‘
result s(Out put) :
In SAP HANA there is no Translate function or similar function is not available , There is a work around using Regular Expression for similar scenario.
SAP HANA Query with out put:
Thanks,
Asif
That's helpful, thanks Asif for sharing.
Regards,
Satish Kumar
Helpful one, Thanks for sharing