There is a little inconsistency of quoting and trimming when the value separator is present in the data and using Apache Common CSV parser.
here in the 3 first cases, the value is correctly parsed
so using separately quoting containing the value separator or spaces to trim works well.
However in the last example that combine quoted value separator and outer spaces to trim, then quoting fails
I think setting org.apache.commons.csv.CSVFormat.withIgnoreSurroundingSpaces(true) on the CSV parser would solve the issue, but I don't see the whole picture to tell if this would have other side effects.