用于在 Java 中将 .txt 文件转换为 .csv 的解析器

Question

我想在 Java 的帮助下将文本文件转换为 excel 文件。示例数据如下，

12A8 3.10 0.82 0.10 06:08:57

12A8 3.07 0.82 0.14 06:08:58

12A8 3.08 0.83 0.12 06:08:59

5C12 1.92 0.66 0.47 06:08:59

12A8 3.09 0.84 0.13 06:09:00

5C12 1.95 0.66 0.50 06:09:01

12A8 3.03 0.85 0.25 06:09:01

12A8 2.98 0.84 0.31 06:09:03

12A8 2.94 0.86 0.39 06:09:03

5C12 2.03 0.70 0.56 06:09:04

12A8 2.91 0.86 0.44 06:09:04

5C12 2.05 0.70 0.57 06:09:04

12A8 3.06 0.86 0.23 06:09:05

12A8 3.00 0.86 0.31 06:09:07

12A8 2.96 0.86 0.38 06:09:08

12A8 2.93 0.79 0.41 06:09:08

12A8 3.07 0.81 0.21 06:09:09

5C12 2.07 0.69 0.60 06:09:10

很明显，每一列都由一个空格分隔。

Answer 1

要将此文档转换为 CSV 文件，您只需将所有空格替换为逗号即可。这是你可以做到的一种方法。&nbsp; &nbsp; &nbsp; &nbsp; final File input = new File("com/aexp/file.txt");&nbsp; &nbsp; &nbsp; &nbsp; List<String> output = new ArrayList<>();&nbsp; &nbsp; &nbsp; &nbsp; BufferedReader reader = null;&nbsp; &nbsp; &nbsp; &nbsp; BufferedWriter writer = null;&nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;reader = new BufferedReader(new FileReader(input));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; String line;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while((line = reader.readLine()) != null){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; output.add(line.replaceAll(" ", ","));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; reader.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;writer = new BufferedWriter(new FileWriter(new File("output.txt")));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for (String s : output) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.write(s);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.newLine();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.flush();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.close();&nbsp; &nbsp; &nbsp; &nbsp; } catch (Exception e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e.printStackTrace();&nbsp; &nbsp; &nbsp; &nbsp; } finally {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; reader.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; writer.close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } catch (IOException e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e.printStackTrace();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }