Also, The first char needs to be '-' fro -ve numbers or blank for +ve numbers.
123.00 -> ' 00000123.00'
-25.30 -> '-00000025.32'
12 -> ' 00000012.00'
-0.45 -> '-00000000.45'
And I've written the following in the transformer and I feel like I've written a piece of clumsy code
Code: Select all
If DSLink2.testNum[1,1] = "-"
Then
"-":FMT(DSLink2.testNum[2,LEN(DSLink2.testNum)],"11'0'R2")
Else
" ":FMT(DSLink2.testNum,"11'0'R2")
thanks in advance,
paul