以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  我想问下怎么去掉字符串里的中文?去掉中文  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=99219)

--  作者:chen3728060
--  发布时间:2017/4/14 18:38:00
--  我想问下怎么去掉字符串里的中文?去掉中文
925 silver all-match necklace 多种佩戴 square式 925 fashion lady gift necklace all-match lady gift necklace
S925 silver Korean style直线 silver 棒 geometry model状 necklace fashion necklace
s925 silver five pointed star eardrop Korean style fashion all-match ethos lady silver CZ setting gift
S925 silver pendant necklace silver jewelry生产供应  Korean style silver jewelry gift jewelry

 

我想在有2000多个这些混了中文的产品标题,我要去掉里面的中文,然后上传到阿里巴巴网站,请问有什么快速的方法?

 

我要的效果↓

 

925 silver all-match necklace square 925 fashion lady gift necklace all-match lady gift necklace
S925 silver Korean style silver  geometry model necklace fashion necklace
s925 silver five pointed star eardrop Korean style fashion all-match ethos lady silver CZ setting gift
S925 silver pendant necklace silver jewelry  Korean style silver jewelry gift jewelry

[此贴子已经被作者于2017/4/14 18:37:45编辑过]

--  作者:chen3728060
--  发布时间:2017/4/14 18:59:00
--  

行了,我自己解决了!

Dim r As Row = Tables("d1").Current
output.show(System.Text.RegularExpressions.Regex.Replace(r("临时列"), "[^0-9\\a-zA-Z]", ""))