cancel
Showing results for 
Search instead for 
Did you mean: 

Field Separator as part of value (Sender)

jegathees_waran
Active Participant
0 Kudos

Hi Friends,

In the input file, all fields in each record are delimited by tilde symbol.

One field has tilde symbol as part of value but the whole value is enclosed with doube quotes. (the highlighted field below)

~Kanaga~"Kannura~"~ ~~0~ ~ ~ ~ ~ ~ ~"K N POLYMATECH CO.,LTD"

When the system parse each field, it consider this one vaue as two values since ~ is in the value.

In the sender channel, FCC parameters the fieldSeparator we use ~.

When I place this kind of file, the sender channel throws error more elements than no.of fields in the channel.

If I remove the ~ sybmol manually in the file, we are able to process the file successfully.

Any idea friends how to control this ?

Thank you.

Kind regards,

Jegathees P.

Accepted Solutions (0)

Answers (4)

Answers (4)

0 Kudos

Hi Jagathees,

You can check link mentioned by Muneesh. It will help you. PFB the content which is useful for you

If you specify xml.enclosureSign= andxml.enclosureSignEsc=““, text enclosed in quotation marks is transferred unchanged and the quotation marks are removed.

If the escape character for a quotation mark (““) itself occurs in the text itself, it is replaced by the quotation mark during the transfer.

Regards,

Sudha

Former Member
0 Kudos

Hi Jagatheeswara,

As mentioned by Ryan, the parameter ROW.enclosureSign should solve your problem.

NameA.enclosureSign -


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.

This parameter is optional.

Please check the below link for reference of the paremeters.

Specifications for File Content Conversion - Architecture and Technology - SAP Library

Also let us know if you have any issues.

Thanks,

Muneesh Gitta.

0 Kudos

Hi Jagathees,

Check the below thread. It answers your issue. Only the field separator is different in your case.

Regards,

Sudha

Ryan-Crosby
Active Contributor
0 Kudos

Hi Jegathees,

You would want to use something like ROW.enclosureSign with a value of "  and that should solve your problem.  Not sure what your tag is so just replace ROW with whatever you are using.




Regards,

Ryan Crosby