Several patches to May 2023 worked to resolve issues with quoted entries when using Modern Style Quoting (MSQ) for multi-line entries in CSV files. These resolved the issues raised at the time but resulted in a change in behavior when parsing quoted entries with a space after the delimiting character.
As an example, the following entry from a CSV:
A,"B
on 2 lines",C
This is parsed correctly as:
This is due to there being no space between the comma and the quoted B field
However the following entry:
A, "B
on 2 lines", C
The entry is parsed as:
The multi-line quoted field is not parsed due to the space after the comma (or whatever delimiter is specified)
Environment
Qlik Sense May 2023
Workaround:
A fix for this behavior will be delivered in a patch at a future date, though where feasible removing the spaces after the delimiting character will allow Qlik Sense to properly parse the file.
Fix Version:
August 2023 Patch 2
May 2023 Patch 6
Cause
Product Defect ID: QB-21429