Skip to Content
0
Former Member
Sep 01, 2006 at 02:39 AM

Flat File problem

21 Views

i have the Flat File format example as below:

Leo

456~123

string1+string2

Nick

478~124

string3+string4

and the target xml should be:

<person>

<name>Leo</name>

<ID>

<SocialID>456</SocialID>

<EmployeeID>123</EmployeeID>

</ID>

<Description>

<JobTitle>String1</JobTitle>

<Address>String2</Address>

</Description>

</person>

<person>

<name>Nick</name>

<ID>

<SocialID>478</SocialID>

<EmployeeID>124</EmployeeID>

</ID>

<Description>

<JobTitle>String3</JobTitle>

<Address>String4</Address>

</Description>

</person>

I have chosen the File Content Conversion File Adapter

but how to set the fieldSeparactor

Thank you for your advice