cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joerg Heinicke <joerg.heini...@gmx.de>
Subject Re: [chaperon] reading Excel CSV
Date Thu, 25 Mar 2004 20:08:07 GMT
On 25.03.2004 20:55, Stephan Michels wrote:

>>I know it's slightly offtopic as I can probably set up the Cocoon part
>>myself. The question is more about the grammar for Chaperon. Has anybody
>>managed to feed Excel CSV files into the pipeline. It would work with
>>the simple quote.grm delivered with Cocoon, but this one is absolutely 
>>not robust. It does not handle surrounding quotes, not to mention double 
>>and triple quotes ("test" in Excel is written as """test""" in CSV). 
>>Even worse it gets when using the delimiter in a cell, this one must be 
>>escaped too.
>>
>>I managed to change the delimiter from comma to semicolon, what was 
>>really easy. And I also managed to get the columns displayed correct 
>>again when a row does contain an escaped delimiter in not more than one 
>>column, but I did not get the value itself to be displayed.
> 
> 
> Hmm, can you provide an example file?

No Excel at hand at the moment, but only Open Office, that surrounds 
every column value with quotes. I have used quote2.txt as base and added 
a sample for both above mentioned problems (17th + 31th of January, both 
2nd column).

Thanks in advance,

Joerg

Mime
View raw message