CODEWITHSUNDEEP
xmlbiztalkbiztalk-2010
Hataf Moin
Hataf Moin

Reputation: 171

Biztalk Server 2010 white space inconsistent behaviour

I am creating a .csv file, using Biztalk Server 2010.

The input message is in XML format and using Flat-File Assembler in custom pipeline.

I have a field in which I am sending 10 white spaces.

Here is my Code : 

<Records xmlns="">
    <Sequence>0015808137001</Sequence>
    <Date>          </Date>
    <FileDate>04/03/2014</FileDate>
</Records>

The elements in in both input and output schema is string type. The issue is when the file get created, it sometimes consists of 10 white spaces and sometimes not.

I have tried this using XML Transmit pipeline, but the issue occurs in the output XML too.

How can i fix this ?

Upvotes: 0

Views: 453

Answers (1)

DTRT
DTRT

Reputation: 11040

Instead of inserting whitespace upstream, like in the Map, you can use some properties on the element in the FlatFile Schema:

  • Minimum Length with Pad Character
  • Pad Character Type
  • Pad Character

That way, you will always get 10 characters, padded, if that satisfies the requirement.

Upvotes: 1

Related Questions