Field Separator as part of value (Sender)

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 17, 2014 at 03:58 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2014 at 05:16 AM

    Hi Jagathees,

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

    Regards,

    Sudha

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2014 at 11:01 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 19, 2014 at 06:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content