Caveats for Allowing and Generating the Plus Sign in Numeric Fields

The following requirements must be noted prior to configuring Sterling B2B Integrator Map Editor and/or translator properties to allow and generate the plus sign in numeric fields:

  • Ensure that the field length is sufficient to accommodate the plus sign—otherwise the data may be truncated. On the input side of the map, the field in which the plus sign will be read must be long enough to accept the addition of a plus sign in the data. Additionally, on the output side of the map, the field to which the data is being mapped must be long enough to accommodate the generation of the plus sign in the data.
  • If you currently use the plus sign as a delimiter (this is a default for EDIFACT), when you add the plus sign to input data, you must use preface the plus sign with the release character you have specified. For example, if you specified the plus sign as the delimiter for elements and specified the release character as a question mark (?), then you would specify the value “5.000” in the data as follows: +?+5.000 (where the first plus sign is the delimiter, the question mark is the release character, and the second plus sign is an actual plus sign in the data).

    If you currently use the plus sign as a delimiter (this is a default for EDIFACT), when a plus sign is generated in your output data, it will be preceded by the release character that you specified.