BizTalk Server Does Not Remove Leading or Trailing Spaces from Numeric Fields (275808)


The information in this article applies to:

  • Microsoft BizTalk Server 2000
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.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbpending KB275808
©2003 Microsoft Corporation. All rights reserved.