Forums

Hello Roman.

I think you should pass to the datasource an url (not a file) providing csv data.

In my code I added

myDataSource.dataType = YAHOO.util.DataSource.TYPE_TEXT;

Hope that helps,
Alberto

Hello Roman.

You may change the field delimeter, for instance, to '#'.

Regards,
IceBox

Hello Todd.

I agree, but it was, of course, a workaround.

Another workaround, it would be tweaking the data in doBeforeCallback.

For instance,

myDatasource.doBeforeCallback = function (oRequest, oFullResp, oParsedResp) {
// Remove the first result (i.e., the headers);
oParsedResp.results.shift();
return oParsedResp;
};

There it could be added a different parsing.

Regards,
Alberto

Edit1:

For instance, (I tested the split with the regex, but not the oParsedResp)



Edit2: This one is better: '"a","b,c, d","e"'.split(/,(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)/)

thank for the replies, I will try the workaround.

I don't want to change the separator for this application since the comma separated values file could be read by Excel without any change and I re-use this file for this reason.

Hello Roman.

I worked out a tiny example, using another approach.

I parsed the response, replacing commas outside the quotes with another delimeter and removing then the quotes. Of course, it is a bit primitive, but you may arrange the parsing for your needs.

http://pastebin.com/3p3Jub7p

Hope that helps,
IceBox