Skip to Content
avatar image
Former Member

Blank spaces are getting trimmed from AL11 text files

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Sep 12, 2012 at 07:36 AM

    >>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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Zameer Hamza Farook

      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

  • Sep 12, 2012 at 09:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 12, 2012 at 10:05 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 02, 2013 at 02:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded