|
Home > Archive > BizTalk Server Applications Integration > October 2005 > Help: Flat File format
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help: Flat File format
|
|
|
| Hi,
I have a message in the following XML format.
<Transaction>
....
<PlantInfo>
<Row>
<PlantName>Rubber</PlantName>
<PlantCount>12</PlantCount>
</Row>
<Row>
<PlantName>Apple</PlantName>
<PlantCount>53</PlantCount>
</Row>
</PlantInfo>
<Transaction>
My customer required me to transform the data in flat file format which
using | (pipe) delimiter. But I am facing some problems in which biztalk
failed to put a | to differentiate the <Row> records within <PlantInfo>.
My current output is
...|Rubber|12Apple|53
And, this is not correct as there shld be a | between 12 and Apple. In
other words, the correct output shld be
...|Rubber|12|Apple|53
So, how can I actually solve this problem?
| |
| mcfarlin_ben@hotmail.com 2005-09-14, 5:52 pm |
| You'll need to add the same delimiter information to the PlantInfo and
Row elements.
| |
| artinv 2005-10-04, 5:53 pm |
| PlantInfo should be be hex and use the carriage return and line feed (0x0D
0x0A)
ROW should be | , character, postfix...hope this helps
"LY" wrote:
> Hi,
>
> I have a message in the following XML format.
> <Transaction>
> ...
> <PlantInfo>
> <Row>
> <PlantName>Rubber</PlantName>
> <PlantCount>12</PlantCount>
> </Row>
> <Row>
> <PlantName>Apple</PlantName>
> <PlantCount>53</PlantCount>
> </Row>
> </PlantInfo>
> <Transaction>
>
> My customer required me to transform the data in flat file format which
> using | (pipe) delimiter. But I am facing some problems in which biztalk
> failed to put a | to differentiate the <Row> records within <PlantInfo>.
>
> My current output is
> ..|Rubber|12Apple|53
> And, this is not correct as there shld be a | between 12 and Apple. In
> other words, the correct output shld be
> ..|Rubber|12|Apple|53
>
> So, how can I actually solve this problem?
|
|
|
|
|