Removing commas before mapping to structure

[Former Member]

All,

Is there a standard function to replace commas with spaces in XI? I am interfacing to a third party with a comma delimited file and commas (within descriptions) are throwing the file off.

What are my options? Please help!

Thanks in advance,

Michael

[henrique_pinto · Accepted solution]

You mean you have a string data field where you want to replace all commas with whitespaces?

Just use the replaceAll standard function in message mapping (under Text types).

[udo_martens]

Hi Michael,

one more option is to use a xsl mapping with function translate:

<xsl:value-of select="translate(current(),',',' ')"/>

Regards,

Udo

[Former Member]

Hi Michael,

If you are picking up a file with flat data which has commas in between its values...pick up the values separately giving NameA.fieldSeparator

as',' and then concat these values while sending it from XI to the target system...u can gve a space while concatenating if you like...this way, i think u will avoid the adapter module code...and other complication that would arise due to a module code..

Regards,

Sushumna

[bhavesh_kantilal]

Michael,

I guess you are using the File Adapters COntent COnversion.

Another option would be to use an Adapter Module and in this module write the java code to convert the <i>comma delimited file and commas (within descriptions)</i> into standrad XML.

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3bdc14e1-0901-0010-b5a9-a01e29d75a6a">How to create Modules for the J2EE Adapter Engine</a>

Regards,

Bhavesh