Hello everyone,
We have a Flat File Definition created in the MEC Mapper to parse a CSV file for processing by our MEC mapping. The FFD is used in the FLAT to XML process in our Extensibility custom agreement.
One of the Alpha fields in the CSV file contains a comma and is properly enclosed inside double quotes as per the CSV standard. However, the FLAT to XML process fails to parse it correctly and splits the value on the comma, causing incorrect values in the subsequent fields.
Is this a known bug or can this be fixed by a tweak in the FFD?