How to sort a CSV file in PHP without loading the entire file into memory?

Question

I'm trying to write a PHP script which will handle sorting of a CSV file by one or multiple columns and outputting the result to another file.

Is there a way to sort the CSV file without loading it entirely into memory?

I was referring to reading rows one by one. So you would read the data but not everything at once. — Alexandru
– Alexandru, Commented Oct 22, 2018 at 11:05

Ben · Accepted Answer · 2018-10-21 20:03:25Z

1

No there is no reasonable way. You need the data in memory to compare and write in a file.

You could try a bubblesort if you know the length of each line. Read one line of origin and last line of a new "ordered" file. Compare them and append or prepend in new file. After this iteration do again with the new file as origin until it is sorted.

You should use a database like MySQL.

answered Oct 21, 2018 at 20:03

Ben

6833 silver badges11 bronze badges

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

1 Comment

Alexandru Over a year ago

Thank you for your suggestion.

Collectives™ on Stack Overflow

How to sort a CSV file in PHP without loading the entire file into memory?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related