Entire flat file in one field using FCC

[former_member474221]

Hi,

How can we read entire flat file into one field using sender FCC?

Thanks

[iaki_vila · Accepted solution]

Hi Hema,

More cases like yours:

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

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

Another alternative without FCC

michal krawczyk's blog XI: XML node into a string with graphical mapping?

Regards.

[former_member184681]

Hi,

Check my reply on the other thread (), it will help you read each line to a separate node, which should be easier for further parsing.

Regards,

Greg

[Former Member]

I have a similar scenario FILE to SOAP, in which I need to map complete content of flat file into a single xml node in the target structure.

I have used sender File Adapter(FCC), and maintained FCC parameters as used by you.

But I am also getting XML as multiple lines of the same node.

My flat file have more than one lines, and what I observed is that it is creating one file content node for every line in the flat file.

What I want is the complete file(all lines) should go in one single XML field.

Please share how you overcome this problem.

My Source File is like

34100000      020261156501000156                    00910 000000008051                                      

34100011C2010000 261156501000156                    00910 000000008051

34100011C2010000 261156501000157                    00910 000000008051

And what i need is

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

- <ns:MT_conteudoTexto xmlns:ns=http://xi.sap.com/abc>

- <conteudoTexto>

  <conteudoTexto>34100000 020261156501000156 00910 000000008051

     34100011C2010000 261156501000156                    00910 000000008051

     34100011C2010000 261156501000157                    00910 000000008051

</conteudoTexto>

Please provide suggestions to acheive this.

[former_member184681]

Hi,

You can try setting conteudoTexto.endSeparator = '0' (a zero in single quotes, including those quotes) but I'm not quite sure if this will work. Give it a try and you will know

Regards,

Greg

[Former Member]

Hi Hema,

          Check the below blog.

http://scn.sap.com/people/jyothi.anagani/blog/2010/06/17/convert-the-input-xml-to-string-in-pi-71-us...

Regards,

Samir

[Former Member]

Check this thread. It may help.

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