整理Endnote导出的TXT文档
从Endnote里面导出的文本文件复制到Excel文件中,里面包含了作者,年份,标题,摘要,关键字以及其他的一些信息,实际上并不需要这么多信息,所以这里用VBA写一个简单的复制粘贴代码就行了
Option Explicit
Sub Move_Sheet()
Dim w1 As Worksheet, w2 As Worksheet
Dim r1 As Range, r2 As Range, r3 As Range, r4 As Range
Set w1 = Worksheets("源数据")
Set w2 = Worksheets("整理数据")
'查找对应字段
Set r1 = w1.Cells.Find(what:="作者")
Set r2 = w1.Cells.Find(what:="年份")
Set r3 = w1.Cells.Find(what:="题目")
Set r4 = w1.Cells.Find(what:="期刊")
'对应列复制到新表里面
w1.Columns(r1.Column).Copy w2.Columns(4)
w1.Columns(r2.Column).Copy w2.Columns(3)
w1.Columns(r3.Column).Copy w2.Columns(2)
w1.Columns(r4.Column).Copy w2.Columns(5)
End Sub
这样就搞定了