by andyroo » Mon Aug 30, 2010 2:06 am
Hi Lowlander, and thank you,
But while that would work for my example above, it won't work for all cases - for example, this title:
Cantate "Cessate, Omai Cessate", RV. 684. II Larghetto e Andante molto. Ah ch'i
is includedin the csv report as follows:
"Antonio Vivaldi","Cantate "Cessate, Omai Cessate", RV. 684. II Larghetto e Andante molto. Ah ch'i","Stabat Mater","5:16",...
which creates problems because it re-parses to:
Antonio Vivaldi | Cantate "Cessate | Omai Cessate", RV. 684. II Larghetto e Andante molto. Ah ch'i | Stabat Mater | 5:16
not to mention that it breaks the csv import to google fusion tables (just uploaded my whole db there) since it's malformed.
But I see the solution, it looks like the export.vbs needs to be expanded to look for embedded quotes, and then needs to properly handle them as per the csv "standards" I referenced above. Too bad my visual basic is sooo rusty... But since the commas are already in quoted fields, it's just the case for double-qotes.
so this line:
"Antonio Vivaldi","Cantate "Cessate, Omai Cessate", RV. 684. II Larghetto e Andante molto. Ah ch'i","Stabat Mater","5:16",...
would become:
"Antonio Vivaldi","Cantate ""Cessate, Omai Cessate"", RV. 684. II Larghetto e Andante molto. Ah ch'i"","Stabat Mater","5:16",...
Hi Lowlander, and thank you,
But while that would work for my example above, it won't work for all cases - for example, this title:
Cantate "Cessate, Omai Cessate", RV. 684. II Larghetto e Andante molto. Ah ch'i
is includedin the csv report as follows:
"Antonio Vivaldi","Cantate "Cessate, Omai Cessate", RV. 684. II Larghetto e Andante molto. Ah ch'i","Stabat Mater","5:16",...
which creates problems because it re-parses to:
Antonio Vivaldi | Cantate "Cessate | Omai Cessate", RV. 684. II Larghetto e Andante molto. Ah ch'i | Stabat Mater | 5:16
not to mention that it breaks the csv import to google fusion tables (just uploaded my whole db there) since it's malformed.
But I see the solution, it looks like the export.vbs needs to be expanded to look for embedded quotes, and then needs to properly handle them as per the csv "standards" I referenced above. Too bad my visual basic is sooo rusty... But since the commas are already in quoted fields, it's just the case for double-qotes.
so this line:
"Antonio Vivaldi","Cantate "Cessate, Omai Cessate", RV. 684. II Larghetto e Andante molto. Ah ch'i","Stabat Mater","5:16",...
would become:
"Antonio Vivaldi","Cantate ""Cessate, Omai Cessate"", RV. 684. II Larghetto e Andante molto. Ah ch'i"","Stabat Mater","5:16",...