[CALUG] Reading CSV using Python / PHP

[Daniel Deighton]

You could try to accomplish your goals with the free version of 
[Splunk](https://www.splunk.com/en_us/download/splunk-enterprise.html). 
You can import, manipulate and export your CSV file.

This [blog 
post](http://blogs.splunk.com/2015/01/30/working-with-spreadsheets-in-splunk-excel-csv-files/) 
should get you started. In general, `inputlookup` and `outputlookup` are 
your friends with CSV files in Splunk.

  -Dan

On 28 Apr 2016, at 10:36, 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 (" 
> ")
>
> Please let me know.
>
> -GG
> _______________________________________________
> CALUG mailing list
> CALUG at unknownlamer.org
> http://lists.unknownlamer.org/listinfo/calug
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.unknownlamer.org/pipermail/calug/attachments/20160428/da58f61c/attachment.html>