File adapter problem

[Former Member]

Hi,

we are reading fixed length file using file content conversion. we are reading each line of a file into a single field of source structure. The file content conversion is removing the multiple white spaces and putting only one spcae instead. i.e

e.g

Please interpret # as a space( " " )

line a input file

"test########test#########test"

after file content conversion the line would look as below.

"test#test#test"

Please let me if there any solution where in I can keep these white spaces even after content conversion.

Thanks

Anand

Thanks

Anand

[cdumont69 · Accepted solution]

Hello,

Put this value in your content conversion for reading each line in one field row.data (the last param is for not trimming white space) :

row.fieldNames data

row.keyFieldValue 1

row.fieldSeparator nl

row.fieldContentFormatting nothing

Regards,

Chris

[Former Member · Accepted solution]

Hi Chirstophe,

Thanks for the response.

we tried the option

row.fieldContentFormatting nothing but only leading and trailing spaces are maintained as they are in the incoming file. but incase of multiple spaces in the middle of character strings are truncated to one space as I had shown previviously. Please let us know if have any idea on this.

Thanks

Anand

[cdumont69 · Accepted solution]

This integration is working in my dev environment.

Are you sure there is no space ?

Because if it's what you see in the SAP GUI, it could be normal. It is due to Internet explorer interpretation that reduce space to one.

So, click right and upload your XML as a file to see the real result.

Hope it helps you !

Regards,

Chris

[Former Member · Accepted solution]

Chris is right - it's only the visual representation on your screen. This threw us for a loop as well. We brought the data in via file, did no mapping, and passed it right back out to a file - and it's ok. In SXMB_MONI, you only see one space in the middle of your data, but it's all there. We are using a native SAP installation, no web screens or Citrix; Basis tells us it's an SAP thing on screen displays, and not uncommon.

[cdumont69 · Accepted solution]

Ok but I think SAP GUI use internet explorer API because on Linux I can't see the XML format. I see all content without tag.

Regards,

Chris