[SOLVED] Concatenation/grouping of rows based on a shared ID
I have been looking for a while but I couldn't find a solution to my problem, so maybe you guys know.
I have a performed a web crawl of a forum (through a seperate web crawler), the data of this web crawl has been written to a CSV.
My problem now is that every entry (original post & replies) is written on a seperate row.
The format of my CSV is as following; in the one column is the title of the topic, one column later the title of the post, and in the last column the actual text of each post.
How can I either combine all the text of one topic in one row or create seperate files per topic, with all the text of the seperate posts in them?
I have added a link to a Google Docs spreadsheet with a small sample of my data.: http://bit.ly/VDXeNU
Thanks a lot in advance!
I have a performed a web crawl of a forum (through a seperate web crawler), the data of this web crawl has been written to a CSV.
My problem now is that every entry (original post & replies) is written on a seperate row.
The format of my CSV is as following; in the one column is the title of the topic, one column later the title of the post, and in the last column the actual text of each post.
How can I either combine all the text of one topic in one row or create seperate files per topic, with all the text of the seperate posts in them?
I have added a link to a Google Docs spreadsheet with a small sample of my data.: http://bit.ly/VDXeNU
Thanks a lot in advance!