Microsoft KB Archive/275808

= BizTalk Server Does Not Remove Leading or Trailing Spaces from Numeric Fields =

Article ID: 275808

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft BizTalk Server 2000 Standard Edition

-



This article was previously published under Q275808



SYMPTOMS
BizTalk Server may not remove leading or trailing spaces from numeric fields when parsing flat file data. This means that space characters are included with the data in numeric fields.



CAUSE
For the purpose of internal processing, BizTalk Server attempts to parse flat file data according to the document specification created in the BizTalk Editor. Document specifications for flat file data contain a property for Pad Characters, which allows users to remove extra characters from field data when parsing. If no pad characters are specified, BizTalk Server defaults to a space character for text fields and a zero for numeric fields. This means that any space characters that are included in numeric fields are not removed.



WORKAROUND
Modify your flat file document specification by doing the following:
 * 1) In the BizTalk Editor, open your flat file document specification.
 * 2) Highlight the node in question.
 * 3) Click the Parse tab.
 * 4) In the Pad Character field, enter Space (0x20) as your pad character.



STATUS
This behavior is by design.

Keywords: kbbug kbpending KB275808

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.