Data Transformation Engine Functions and Expressions Reference Guide

Appendix B - Format Strings Number Format Strings
Functions and Expressions Reference Guide
248
Leading Sign Format Strings
Sub-String
Name
Sub-String Value Positive Negativ
e
Leading-Sign "L" + Positive + Negative + Zero(1)
-or-
Req Req
"L" + "[" + Positive + "]" + Negative +
Zero(1)
-or-
Opt Req
"L" + Positive + "[" + Negative + "]" +
Zero(1)
-or-
Req Opt
"L" + Positive + Zero(1)
-or-
Req —
"L" + Negative + Zero(1)
— Req
Trailing Sign Format Strings
Sub-String Name Sub-String Value Positive Negative
Trailing-Sign "T" + Positive + Negative + Zero(1)
Req Req
-or-
"T" + "[" + Positive + "]" + Negative +
Zero(1)
Opt Req
-or-
"T" +
Positive + "[" + Negative + "]" +
Zero(1)
Req
Opt
-or-
"T" + Positive + Zero(1)
Req —
-or-
"T" + Negative + Zero(1)
— Req