on 06-17-2014 4:48 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.