[CALUG] Reading CSV using Python / PHP

[Berend Tober]

Rajiv Gunja wrote:
> Hey all, I am trying to cut down on the amount of manual steps I have to
> take editing CSV file - sorting, creating new tabs and categorising them.
> I googled and found logparser from MS, could not figure it out - maybe a
> mental block towards anything MS.
>
> I saw that it was possible using python or PHP. So turning to you guys
> for advice. Which one works best or is there a different way?
>
> I do not know Python, but I can learn. PHP, I am very familiar with, but
> whichever is efficient and can do a better job, I will use it.
>
> Problem:
> 1. CSV file has 2000+ rows
> 2. Some columns are multi-line with \r and \n
> 3. fields are separated by "," and each data item is between quotes (" ")
>

Your problem #2 is really a problem, but barring that, I have had great 
success with CSVKIT, which happens to be a Python implementation, but 
you don't have to know that in order to use the utilities.