FCC in SAP PI

[Former Member]

Hi All,

I have a following structure as flat file:

ABC DEF

XYZ - 0909

I am doing good

-

and i want to convert this file into XML format without creating IR objects and also i want entire content to be under one node.

as

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

<File_Content>ABC DEF XYZ - 099 I am doing good -</File_Content>

What Content Conversion can i give in parameters so that i can get the above o/p?

[Former Member]

Hi, to concatenate all lines of the file into one single line you can try to use conversion parameter enclosureSignEndEscape in order to replace the line break with space.

[Former Member]

Hi Martin,

And what value should i give to this conversion parameter?

[Former Member]

Thank you Martin, but this is not working.

[Former Member]

Hi again, another possibility would be to use a batch script modifying the file and calling the script with OS command before message processing.

Regards, Martin

[Former Member]

Hi Martin, this solution cannot be implemented in my work area. Can you provide me with any other solution?

[Former Member]

Hi, can you read the file line by line (one node per line) and concatenate the lines on the receiver side?

Otherwise there is still the possibility of creating an adapter module as Shabarish mentioned above.

[Shabarish_Nair]

this is not possible in FCC. If you still want to avoid IR objects, then go ahead with a module and then create the XML