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