7,763
社区成员
发帖
与我相关
我的任务
分享
Set fso = createobject("scripting.filesystemobject")
curdir = fso.getparentfoldername(wscript.scriptfullname)
inputpath = fso.buildpath(curdir,"data.txt")
Set stream = fso.opentextfile(inputpath,1,False)
content = stream.readall()
stream.close
Set reg = createobject("vbscript.regexp")
reg.Global = True
reg.ignorecase = True
reg.multiline = True
reg.pattern = "[ \t]+"
content = reg.Replace(content,",")
outputpath = fso.buildpath(curdir,"data.csv")
Set stream = fso.opentextfile(outputpath,2,True)
stream.write content
stream.close
msgbox "done!"