Handling tab through pi 7.0

[Former Member]

Hello Everyone,

I have a file to proxy scenario. The file is a hash(#) seperated .txt file. sometimes in the file, tab is coming in place of space. For example, if the value is ABC XYZ, between ABC and XYZ tab is coming in place of space. As a result, in the ECC table through proxy it is getting populated as # i.e ABC#XYZ.

Through sap pi 7.0, i have to handle this problem. How to detect tab and replace it with space through pi 7.0 so that the value will be populated as ABC XYZ, not as ABC#XYZ.

Please help ASAP.

Regards,

Ashmita

[former_member192343]

Hi, Ashmita

You can use stringReplace function in graphic mapping.

For first constant I inserted tab char (copied it from notepad++), for second constant - space char

Regards,

Mikhail

[Former Member]

Ashmita

plz use Content conversion parameters:

Tab:0X09

Name------------------------------------------------Value

RecordsetStructure.fieldSeparator----------'0X09'

chk the below link(Converting File Content in a Sender Adapter)

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

...Mutti