[Tutor] Malformed CSV

[Jan Eden]

Kent Johnson wrote on 02.12.2005:

>Jan Eden wrote:
>>I guess I need to notify the engineer responsible for the CSV
>>output and have the quoting corrected.
>
>If that is possible it is a much better solution. I hate to hack
>around bad data - much better to correct the source of the data if
>possible.
>
Right.

>In fact you may have little choice if you want to use the CSV module
>- for example what if the first field has commas and quotes? Could
>you have a line like this? ""hotel", "budapest",
>"billig"","1","0","0"
[...]
>
>BTW do you really have doubled quotes in all the hotel fields, or
>just the one with quotes? The data in your original post is
>inconsistent.
>
Yes, and that's the source of my problem: The data is based on user input to Google, which tends to be extremely inconsistent. Users seem to use any kind of absurd quoting, like

hotel" "miami"
"miami","hotel

Thanks again,

Jan
-- 
Life's unfair - but root password helps!