字符串 批量全角、半角转换

 

全角转为半角

ADDRESS=KTRANSLATE(ADDRESS,'1234567890()','１２３４５６７８９０（）');

ADDRESS=KTRANSLATE(ADDRESS,'ABCDEFGHIJKLMNOPQRSTUVWXYZ','ＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ');

另一种方法：TRANWRD(ADDRESS,'？','?');

转载于:https://www.cnblogs.com/Anni-love-Ferris-wheel/p/7462786.html