Data Transformation Engine Functions and Expressions Reference Guide

Appendix B - Format Strings Number Format Strings
Functions and Expressions Reference Guide
250
Sub-String
Name Sub-String Value Meaning
Fraction
"V" + ImpliedPlaces
- or –
Value + MinDigits(1) + "##" +
MaxDigits(1)
- or -
"[" + Value + MinDigits(1) + "##" +
MaxDigits(1) + "]"
Specifies the decimal to be
implicit and implied places
specifies where the intended
decimal separator is to be
placed.
Specifies the value of the
decimal separator to be
required and the range of
fraction digits. If min-digits is
not used, default is zero. If
max-digits is not used, default
is "S"
Specifies the value of the
decimal separator to be optional
if there is no fractional portion
of the number. It also specifies
the range of fraction digits. If
min-digits is not used, default is
zero. If max-digits is not used,
default is "S"