Issue in xml to tab seperated content conversion

[Former Member]

Hi,

I am having proxy to file scenario, in few columns data is coming like "AAA""B, in moni, xml data seems to be fine, but when the Excel file is genertaed at the FTP, the leading cell values are getting appended to this value.

e.g.

A B "ABC""D E F

but it gets genertaed like

A B "ABC""D E F

the E and F values are populating in the same cell having " in between/beginning.

In the incoming data cell value, the " can appear anywhere, and we want to populate the same data in tab sepertaed file.

Please provide your inputs how can we handle this.

Thanks,

Ayura

[Former Member]

Field separator is tab

line separator is 'nl'

Edited by: Ayura Kanungo on Dec 23, 2011 6:21 AM

[Former Member]

Ayura,

Why dont you use enclosureSign parameter in FCC and try?

Refer: http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

NameA.enclosureSign ="

NameA.enclosureConversion = NO

Regards

Ramesh

Edited by: Ramesh P on Dec 23, 2011 11:12 AM

[Former Member]

Ayura,

What have given for field separtor and line separator?

regards

Ramesh