AutoHotkey Community

There is something inconsistent with handling quoted commas.L1 is parsed to [a] and [a,b], which is right.
L2 is parsed to [a] and [''a] and [b"], just because of the space in front of "a..., the quotes become normal characters.
L3 is parsed to [a] and [a "] and [b], quite unexpected. One quote becomes normal character, the second one disappears. I’d like to see [a] and [a "," b].

I see what you mean. However, I don't think the examples you gave are proper CSV format (to the extent that there is such a thing). I think the biggest problem is the space after the comma: I'm pretty sure that is invalid in all CSV formats unless it's to be part of the literal text in that field.

The program was written to parse CSV files from Excel. Of course Excel isn't the only source of CSV files, but I'd hoped the design would handle the most common formats.

Even if it turns out that this should be fixed -- which I'm in doubt about but will gladly discuss further -- doing so would likely break existing scripts that rely on the current behavior.

Thanks for reporting it.