Sender FCC, text delimiter occurs within text
I have a File Sender Adapter with FCC configured. The file is actually a csv file.
the field separator is comma ,
the text delimiter is quotation mark "
Example of the content is:
some times the content is like the following:
notice the second field is B"H, it contains the quotation mark character which is the text delimiter. This ends up in the field is not parsed correctly within the FCC and generates a mapping error.
How can we handle this?