Blank spaces are getting trimmed from AL11 text files

[Former Member]

Hello,

I have to read fixed length TXT file from AL11 of PI and post it to ECC

Uploaded TXT file from my desktop to AL11 of PI using SXDA_TOOLS

TXT file having blank spaces at the end of each record but when PI reading the TXT file using FCC fixed lengths, those blank spaces are getting trimmed and not even getting empty tags.

More over if iam not using Records.lastFieldsOptional it is assuming that missing last fields and throwing error since iam using field fixed length.

When i download the same file from AL11, blank spaces are missing from there also. If i process the file from shared folder, it is perfectly alright.Problem is with only AL11.

Any one faced this type of issue?

Regards

Sesha

[Former Member]

Hello All,

In my case, I am uploading an XML file from Presentation server to PI Application server using SXDA_TOOLS. On viewing this file in AL11, I can see that few spaces are getting added in the very end of the XML content.

I have tried re-uploading the file by removing these spaces but no help.

Kindly suggest how this can be resolved.

Regards,

Aman

[former_member190546]

Hi Seshagiri,

I hope while uploading the file to AL11, It is taking 512 characters of your input message and removing empty spaces.  Please check with your Basis team about this. As a result it is giving issue with AL11 and not with other system like shared drive/filezilla. (Tools).

rgds

Umamahesh.

[Former Member]

my file is 200 Char length only

Regard

[anupam_ghosh2]

Hi Sesha,

              Please check this link http://help.sap.com/saphelp_NW04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

NameA.fieldContentFormatting

○       Enter trim to remove all the leading and subsequent blanks for a value found. This is the default.

○       Specify nothing to ensure that the value remains unaltered.

This will preserve the spaces in xml field after FCC.

Regards

Anupam

[Former Member]

Anupam,

Tried with

Records.fieldContentFormatting

nothing

  but no use

Regards

[zameerf]

>>If i process the file from shared folder, it is perfectly alright.Problem is with only AL11.

I hope you are doing some tests and stuck with this approach of AL11 and SXDA_TOOLS.

As you said, when you access the shared folder directly it works.

So, this should not be an issue with your configuration or interface.

Refer the below thread which discuss similar issue when using these transactions.

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

[Former Member]

So, this should not be an issue with your configuration or interface.

Exactly, the problem is once i upload the file to AL11 it starts there onwards.

The link which u gave is not talking about trimming blank spaces.

I have to read file from AL11 itself using file adapter even in production system. So this is not enough to take basis help to check the file and all.

Regards

Sesha

[zameerf]

>>Exactly, the problem is once i upload the file to AL11 it starts there onwards.

Since you use transaction AL11, you face this problem.

Just try to directly access the file system and upload files, may be a FTP client like FileZilla can help.

Hope you won't face the issue this way.

[Former Member]

Zameer,

If i use shared folder or file system to place the files and pull them from there into PI, no issues .

The only problem is with AL11, but i must go thru AL11 only. No other go. I have to use AL11 for entire DEV--QA--PRD

Regards