Parser for Converting .txt file to .csv in Java

Question

I want to convert the text file to excel file with the help of Java. The example data as like below,

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

As it is obvious, each column is seperated by a space.

Possible duplicate of Parse .txt to .csv

beefoak
– beefoak

2018-10-03 13:34:53 +00:00
Commented Oct 3, 2018 at 13:34 — beefoak
– beefoak, Commented Oct 3, 2018 at 13:34
@beefoak thnx!!

Beste Iskemleci
– Beste Iskemleci

2018-10-03 13:43:17 +00:00
Commented Oct 3, 2018 at 13:43 — Beste Iskemleci
– Beste Iskemleci, Commented Oct 3, 2018 at 13:43

Adam · Accepted Answer · 2018-10-03 14:31:37Z

1

To turn this document into a CSV file you just need to replace all the spaces with commas. Here's a way you could do it.

        final File input = new File("com/aexp/file.txt");
        List<String> output = new ArrayList<>();
        BufferedReader reader = null;
        BufferedWriter writer = null;
        try {
             reader = new BufferedReader(new FileReader(input));
            String line;
            while((line = reader.readLine()) != null){
                output.add(line.replaceAll(" ", ","));
            }

            reader.close();

             writer = new BufferedWriter(new FileWriter(new File("output.txt")));
            for (String s : output) {
                writer.write(s);
                writer.newLine();
            }

            writer.flush();
            writer.close();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                reader.close();
                writer.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }

answered Oct 3, 2018 at 14:31

Adam

1,7541 gold badge13 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Beste Iskemleci Over a year ago

Thank you so so so much!! I will try it :)

Collectives™ on Stack Overflow

Parser for Converting .txt file to .csv in Java

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related