Wrong Chapter Markers on svn6207

[Iosue]

I imported the markers from this cvs file:

1,\
2,序曲
3,第１乐章 Allegro energico\,ma non troppo. Heftig\, aber markig
4,第２乐章 Scherzo.Wuchtig
5,第３乐章 Andante moderato
6,第４乐章 Finale\, Andante moderato–Allegro energico

But it is converted into something like this:

Top: Original csv, in case the forum doesn't support the encoding.
Bottom: Chapter Markers seen in iTunes

[Iosue]

I am happy to see it tempered in svn6210. But then, something still doesn't come right.

1. When the cvs is imported, all the stuff after the commas are cut off. Manually putting the stuff back works fine.
2. The chapter markers display properly in The KMPlayer (although the player always mistake chapter markers as subtitles), but not in iTunes.

[TedJ]

I am happy to see it tempered in svn6210. But then, something still doesn't come right.

1. When the cvs is imported, all the stuff after the commas are cut off. Manually putting the stuff back works fine.

What does the C in CSV stand for? Make sure you're escaping any embedded commas with a backslash.

[Iosue]

I am happy to see it tempered in svn6210. But then, something still doesn't come right.

1. When the cvs is imported, all the stuff after the commas are cut off. Manually putting the stuff back works fine.

What does the C in CSV stand for? Make sure you're escaping any embedded commas with a backslash.

All the commas are escaped. The file was exported by Handbrake and all commas are already there. When Handbrake imports this file back, the lines becomes like this:

1,\
2,序曲
3,第１乐章 Allegro energico\ <------ cut off there
4,第２乐章 Scherzo.Wuchtig
5,第３乐章 Andante moderato
6,第４乐章 Finale\ <------ cut off there

And the characters still look like the iTunes screenshot, except chapters 1, 2 and 4 now display a correct entry, just incorrectly encoded.

[Woodstock]

What does the C in CSV stand for? Make sure you're escaping any embedded commas with a backslash.

Actually, any value that contains a comma should be wrapped in quotes, and any quotes within a value escaped by doubling it. If the library that is exporting the CSV changed a comma to "\,", then it's not a particularly compliant library...

This would be a more standard way of representing the list in CSV:

Code: Select all

2,序曲
3,"第１乐章 Allegro energico,ma non troppo. Heftig, aber markig"
4,第２乐章 Scherzo.Wuchtig
5,第３乐章 Andante moderato
6,"第４乐章 Finale, Andante moderato–Allegro energico"

(I deal with dozens of variants of CSV every week at work)

[Iosue]

It is also possible to have a " in these markers. Do you suggest using "" or \"?
Besides, I think using Regular Expression to capture it would also be fine, like
[0-999], (.*?)\r\n

Besides, there are also problems on parsing these non-Latin words there. It worked fine with 0.9.9.1. Maybe we need to do it with Unicode?

[Woodstock]

The most usual way of encoding a " character is to double it up, i.e.:

Code: Select all

2,序曲
3,"第１乐章 Allegro energico,ma ""non troppo"". Heftig, aber markig"
4,第２乐章 Scherzo.Wuchtig
5,第３乐章 Andante moderato
6,"第４乐章 Finale, Andante moderato–Allegro energico"

I have not seen \" used in any of the systems I've encountered, but, I have not seen everything out there.

[Iosue]

I haven't either. But Regular Expression seems to cover it all.