java shell command to sort csv file

Question

i need to sort a csv file by the first column, which is a timestamp. I've been trying to do this with the following code, but the inputstream of the process p is always just blank:

    Process p = Runtime.getRuntime().exec("sort -k1,1 -t, Bucket_Stats.csv");
    p.waitFor();
    // read this file into InputStream
    InputStream in = p.getInputStream();
    OutputStream output = new FileOutputStream("Sorted_Bucket_Stats.csv");
    System.out.println(IOUtils.copy(in,output));
    output.flush();
    output.close();

why don't you use the -o flag of the sort command?

jlordo
– jlordo

2013-08-06 00:09:10 +00:00
Commented Aug 6, 2013 at 0:09 — jlordo
– jlordo, Commented Aug 6, 2013 at 0:09
you are a saint. make this an answer so i can thank you

user1553248
– user1553248

2013-08-06 00:21:26 +00:00
Commented Aug 6, 2013 at 0:21 — user1553248
– user1553248, Commented Aug 6, 2013 at 0:21

jlordo · Accepted Answer · 2013-08-06 00:30:34Z

2

Instead of handling the output in Java, you can use the

-o or --output=FILE

flag of the sort command and pass a filename for the output.

If you pass the same filename as the input, it will be overwritten.

answered Aug 6, 2013 at 0:30

jlordo

37.9k7 gold badges63 silver badges84 bronze badges

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

Collectives™ on Stack Overflow

java shell command to sort csv file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related