decimal data type

Home Page Forums BizTalk 2004 – BizTalk 2010 decimal data type

Viewing 1 reply thread
  • Author
    Posts
    • #14630

      HOW TO SPECIFY A DECIMAL DATA TYPE PRECION

      EX.

      IF THE MESSAGE CONTAINS 2.3 IT SHOULD LOOK LIKE 0002.300

    • #14631

      You can declare your own Xsd simpleType in your schema
      e.g
      <simpleType name=’mydecimal’>
      <restriction base=’decimal’>
      <totalDigits value=’4’/>
      <fractionDigits value=’3’/>
      </restriction>
      </simpleType>

      Although, this just restricts content rather than enforcing how the decimal is represented
      e.g. 2.3 and 0002.300 are both valid but 2.3004 would not be valid.

      If it just a matter of the string format of a number this needs to be handled in a map with a script/custom functoid/extension that will produce the desired format

      [code:1:0c4f73e536]Decimal.ToString(\"0000.000\")[/code:1:0c4f73e536]

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.