全角转为半角
ADDRESS=KTRANSLATE(ADDRESS,'1234567890()','1234567890()');
ADDRESS=KTRANSLATE(ADDRESS,'ABCDEFGHIJKLMNOPQRSTUVWXYZ','ABCDEFGHIJKLMNOPQRSTUVWXYZ');
另一种方法:TRANWRD(ADDRESS,'?','?');
全角转为半角
ADDRESS=KTRANSLATE(ADDRESS,'1234567890()','1234567890()');
ADDRESS=KTRANSLATE(ADDRESS,'ABCDEFGHIJKLMNOPQRSTUVWXYZ','ABCDEFGHIJKLMNOPQRSTUVWXYZ');
另一种方法:TRANWRD(ADDRESS,'?','?');
转载于:https://www.cnblogs.com/Anni-love-Ferris-wheel/p/7462786.html