Skip to Content

Sender FCC, text delimiter occurs within text

Dear Experts,

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:

"A","B","C","D","E"

some times the content is like the following:

"A","B"H","C","D","E"


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?




Thank you,

Suwandi C.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • May 25, 2015 at 12:36 PM

    the text delimiter is quotation mark "

    What is text delimiter? How did you configure it in FCC?

    Add comment
    10|10000 characters needed characters exceeded

    • In the same page as you mentioned, I think this will do the trick.

      NameA.enclosureSignEscape

      Specify a string that replaces the text delimiter if it occurs within a text that it delimits.

      When the text is transferred the string is replaced by the value specified in NameA.enclosureSign. This parameter is optional.

      NameA.enclosureSignEscape "


  • Aug 28, 2015 at 04:35 AM

    Hi all,

    I ended up changing the enclosure Sign to other than ", since the sender system could not replace the character to an escape character. Otherwise, we could use the enclosure Sign Escape.

    Thank you,

    Suwandi C.

    Add comment
    10|10000 characters needed characters exceeded