how to replace comma

[former_member190536]

Hello,

I am running proxy to file scenario (csv).

I am using field separator as comma (,) in module parameters.

When comma comes in data then it is separating as another filed. Is there any parameter available module? with out changing the mapping.

Regards,

Khaja.

[baskar_gopalakrishnan2]

you might also considering writing simple java mapping to replace the comma using java string class. This is purely how to do  escape the special character within the string.

Another feasible approach is change the seperator pattern to something like & or % or $ instead comma and see if that helps.

[ambrish_mishra]

Hi,

Please go through the link below.

http://help.sap.com/saphelp_nw73/helpdata/en/0D/00453C91F37151E10000000A11402F/frameset.htm

xml.enclosureSignEscape= 

Here you can 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 xml.enclosureSign. The default setting is no value.

Hope it helps!

Ambrish

[ambrish_mishra]

Hi Khaja,

below link should help you. My earlier response is applicable only in case the field comes with a delimiter like "" then you can use xml.enclosureSign=" and xml.enclosureSignEsc=" " in your FCC.

http://scn.sap.com/thread/2122344

Ambrish

Message was edited by: Ambrish Mishra

[Former Member]

do it in the proxy before it gets sent to PI.