主题：求助 如何替换某列的字符

  如何才能批量把 电话列 中的文字等符号替换掉，还有性名列中的 字母！

替换后的效果，请你表示出来看看

手工删除多余字符后的结果！@
此主题相关图片如下：结果.png

使用软件难道还要把数据做成这样子的来用？也许是多余的话。

导入的数据就是这样的混乱，总得要清理吧！

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:ddd.egd

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:替换_源.egd

 请教老师，这段代码如何读懂？ EvalFor(GridName,"姓名1","Eval(Rept(""Substitute("",26) + """""""" + Upper([姓名]) + """""","""""" + Substitute(""A|B|C|D|E|F|G|H|I|J|K|L|M|N|O|P|Q|R|S|T|U|V|W|S|Y|Z"",""|"","""""",""""""""),"""""") + """""","""""""")"")") And CreateGrid(".","电话",0) And AddRows(".",Len(ListFor("表1","电话",1))-Len(Substitute(ListFor("表1","电话",1),"|",""))) And EvalFor(".","电话","Eval(""Split(""""""+ListFor(""表1"",""电话"",1)+"""""",""""|"""",Row)"")") And EvalFor(".","电话","Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute([电话],""1"",""""),""2"",""""),""3"",""""),""4"",""""),""5"",""""),""6"",""""),""7"",""""),""8"",""""),""9"",""""),""0"",""""),""p"","""")") And DelFor(".","电话","=","") And EvalFor("表1","电话1","Substitute(Eval(Rept(""Substitute("",[.!Rows])+""[电话],""""""+Substitute(ListFor(""."",""电话"",2),""|"","""""",""""""""),"""""")+"""""","""""""")""),""|"","","")") And RemoveGrid(".")

从算术--代数--高等数学------；不要急于求成！

想当年想考政治经济学研究生，里头就要求“高等代数”，对我这个文科生来说，难度太大，就放弃了。。。