Sender FCC, text delimiter occurs within text

[suwandi_cahyadi]

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.

[suwandi_cahyadi]

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.

[former_member183816]

the text delimiter is quotation mark "

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

[suwandi_cahyadi]

Hi,

Actually it is the Recordset.enclosureSign that I configure in the FCC.

As from the following page:

Converting File Content in the Sender Adapter - SAP XI: Runtime - SAP Library

It is described as:

Specify a string here that acts as a text delimiter. Text enclosed by such delimiters is transferred to the target structure unmodified although the default setting is to remove all text delimiters. Separators within such texts are ignored.

[former_member183816]

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               "