fbabinea
May 30th, 2002, 08:15 AM
Hi there,
I'm working w/ BizTalk to map a flat file to an xml file. I've created both specifications & map.
The specification for the incoming document is a CUSTOM, with , as the field delimiter and CR as the record delimiter. Fields also have a wrap character of ". Everything is fine, except for the first field in the second record and on... It keeps the wrap character!
For instance, this would be a sample of my text file:
"Smith","John","sales rep"
"Doe","Jane","customer service rep"
And this is what comes out from BizTalk Editor when I validate instance:
<EmployeeInfo>
<Employee lastname="Smith" firstname="John" title="sales rep" />
<Employee lastname=""Doe"" firstname="Jane" title="customer service rep" />
</EmployeeInfo>
Any ideas???
I'm working w/ BizTalk to map a flat file to an xml file. I've created both specifications & map.
The specification for the incoming document is a CUSTOM, with , as the field delimiter and CR as the record delimiter. Fields also have a wrap character of ". Everything is fine, except for the first field in the second record and on... It keeps the wrap character!
For instance, this would be a sample of my text file:
"Smith","John","sales rep"
"Doe","Jane","customer service rep"
And this is what comes out from BizTalk Editor when I validate instance:
<EmployeeInfo>
<Employee lastname="Smith" firstname="John" title="sales rep" />
<Employee lastname=""Doe"" firstname="Jane" title="customer service rep" />
</EmployeeInfo>
Any ideas???