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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
20 | |
9 | |
8 | |
7 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 |