Doubt regarding File Content Conversion.

[Former Member]

Hi Experts,

my scenario is : XML - >XI -> FCC

my input is:

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

<ns0:FCC_MT xmlns:ns0="urn:passhe.com/TestXMLtoFCC">

<Name>

<Fname>firstname</Fname>

<Lname>last name</Lname>

</Name>

<Address>

<Street>springford dr</Street>

<Zip>1234567</Zip>

</Address>

</ns0:FCC_MT>

Parameter i have given in Recever File Adapter:

Record Structure: Name,Address

Name.fieldNames: Fname,Lname

Name.fieldFixedLengths: 15,15

Address.fieldNames: Street,Zip

Address.fieldFixedLengths: 20,10

I am getting below Out put.

firstname last name

springford dr 1234567

My requirement is out put shoule come in a single row like:

firstname last name springford dr 1234567

Please advice me how to do get desired output. i have searched in SDN, i am not able to get how to get record in sigle row.

thanks

dhanush.

[Satyagadadas]

ns0:FCC_MT xmlns:ns0="urn:passhe.com/TestXMLtoFCC">

<Name>

<Fname>firstname</Fname>

<Lname>last name</Lname>

</Name>

<Address>

<Street>springford dr</Street>

<Zip>1234567</Zip>

</Address>

</ns0:FCC_MT>

Use recordSet Structure : FCC_MT,Name,Address

FCC_MT.fieldNames : Name,Address

FCC_MT.FieldSeparator:

then name and address fields

[Former Member]

Hi Satya,

What should i give in field saparator, i do not want ' ,' r new line "nl', just i want to get metioned output.

Thanks,

Dhanush