Skip to Content
author's profile photo Former Member
Former Member

Extra Blank Line gets added at the Beginning of the text file

Hello All,

I have created abap proxy to File Adapter scenario in PI 7.1 and I am using Content Conversion in the File Adapter to convert the payload structure to flat text file. The input Structure is simple as follows:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_Test xmlns:ns0="http://test.com">

<Filename/>

<DTL>

<Name/>

<ID/>

</DTL>

</ns0:MT_Test>

And in Receiver file content conversion I am using the following parameter

DTL.addHeaderLine 0

DTL.FieldNames Name,ID

DTL.fieldSeparator ,

DTL.endSeparator 'nl'

DTL.fieldContentFormatting nothing

And I am using variable substitution to get the filename.

Please help in removing the blank header line

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Dec 10, 2014 at 07:02 AM

    Hi Ramya,

    1. Please try to use the FCC parameters as suggested in the following links and check if it works.

    Create another node, under that node(FileNode) create one filename element like Filename. Use content conversion like below

    FileNode.fieldFixedLengths 0

    FileNode.fixedLengthTooShortHandling Cut

    FileNode.endSeparator '0'

    2. Else go for Dynamic Config option

    Dynamic file name and directory in Receiver File Adapter - summary of possibilities - Process Integration - SCN Wiki

    (Adapter-Specific Message Attributes and Dynamic Configuration)

    Regards,

    Azhar

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 10, 2014 at 05:23 AM

    Dear Ramya,

    Please use the document offset in FCC for removing extra lines .

    Please check the link

    Warm Regards,

    Rudra

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.