如何将文本日志文件导入到 Excel 列中 [英] How to import a text log file into a excel columns

问题描述

我有一些表单数据

[39645961,-79966658]358920045121212[0.75]2013-01-30 20:47:52
[39646124,-79966771]358920045121212[0.5]2013-01-30 20:47:54
[39646134,-79966733]358920045121212[0.5]2013-01-30 20:47:56
[39646123,-79966723]358920045121212[0.5]2013-01-30 20:47:58
[39646144,-79966724]358920045121212[0.5]2013-01-30 20:48:09
......

如何将它们导入到 excel 文件中的单独列中.喜欢

How can I import them into an excel file into separate columns. like

39645961 -79966658 358920045121212 0.75 2013-01-30 20:47:52
39646124 -79966771 358920045121212 0.5 2013-01-30 20:47:54
39646134 -79966733 358920045121212 0.5 2013-01-30 20:47:5

有什么想法吗?

推荐答案

如果不是太频繁的任务:

If it's not too frequent task:

1. 将文本复制粘贴到 Excel(将占据一列)
2. 数据 - 文本到列 (Excel 2003)
3. 分隔符:逗号和其他:]
4. 完成操作后，在剩余的未拆分片段 (358920045121212[0.75) 后面插入一列，并重复 Text to Columns for this column only with Other delimiter as [>.

1. Copy-paste the text to Excel (will occupy one column)
2. Data - Text to Columns (Excel 2003)
3. Delimiters: Comma and Other: ]
4. After completing the operations, insert a column after the remaining non-splitted fragment (358920045121212[0.75) and repeat Text to Columns for this column only with Other delimiter as [.

这篇关于如何将文本日志文件导入到 Excel 列中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！