SQL

SQL中級・電話番号を整形する

投稿日:

WITH test AS(
    SELECT ' 0 90-12 34ー56あアiⅠi78' AS ContactPhone__c
)
SELECT REGEXP_REPLACE(NORMALIZE(ContactPhone__c, NFKC),'[^0-9]','')
FROM test

-SQL

Translate »

Copyright© 解決方法あった! , 2022 All Rights Reserved Powered by STINGER.