|
按你规则。- Sub Macro1()
- Dim arr(1 To 1000, 1 To 2), tmp
- Open ThisWorkbook.Path & "\提取特殊文本内容.txt" For Input As #1
- Do While Not EOF(1)
- Line Input #1, tmp
- tmp = Trim(tmp)
- If InStr(tmp, "-") > 0 Then
- n = n + 1
- arr(n, 1) = tmp '读入每行
- k = 0
- Else
- k = k + 1
- If k <= 5 Then arr(n, 2) = arr(n, 2) & tmp
- End If
- Loop
- Close #1
- If n > 0 Then Sheet1.[a1].Resize(n, 2) = arr
- End Sub
复制代码 |
评分
-
查看全部评分
|