[PLUGIN] CSV, CSV2Array, CSV2Dictionary

plugin: csv

plugin: csv2array

plugin: csv2dictionary

tool: execel2csv

rex_taffydb, a plugin of database.

Oh this sounds useful. Nice addition !

Keep up the good work rexrainbow.

This looks interesting rexrainbow.

Thanks for this and your other plugins. Looking forward to more.

Note that YQL can output any of its data to csv.

Tnx a lot Rex

Thanks for this Rex.

This seems to work well for me, but is there a way to have commas in a cell without it screwing up the loading of an array? For example, if I want a string value of "Hello, how are you?" in one cell, is there a way to specify that that comma NOT be interpreted as a new cell?

theletterm

I think "Hello, how are you?" can be parsed in this csv parser to get whole string with ",".

Ah, I see, that seems to work. Thanks!

Hi Rex,

I don't understand what you said about using double quotes for comma in a string. Please do you has a sample?

Thanks

Excel:

<img src="http://i1081.photobucket.com/albums/j352/rexrainbow1/csv_sting.png" border="0" />

CSV:

,Bill,Jerry
Talk,"Hi, good morning",What's funny

Hi, good morning -> "Hi, good morning"

What's funny -> What's funny

Thanks

Hi!

I have a problem with this plugins.

I can't use a data Cell with a "," in it.

I tried the double quotes, but it don't work.

If I put this Csv string :

",WARRIOR,THIEF,MONKS

HP,100,70,50

ATK,"5,5",7,2

DEF,3,1,1"

It just don't accept it.

Thanks for the Help

R73 by the way

Is it possible to parse JSON data with API's, Like this -

api.twitter.com/1/trends/current.json

smitchell

CSV plugin mainly parses CSV text file, so it's better making another plugin like hash to parse JSON string.

But the JSON string maybe return a array....

Anyway, I can make a hash plugin to do this.

guicole

It's work fine in my C2 editor. The csv plugin can parse it.

If you paste the CSV string into C2 editor, remember to replace " to ""

",WARRIOR,THIEF,MONKS
HP,100,70,50
ATK,""5,5"",7,2
DEF,3,1,1"