Hi All,
I need to convert an -9(03).9(02) (of value say -001.45) to
a printed value of -1.45
Reason being so I can string these values into a comma delimited file. Leading zeroes are suppressed and no trailing or leading spaces.
If i were to define the field as -ZZ9.99 then the printed value will be - 1.45 with two blank positions between the sign and 1 which is my problem at the moment. Not that I need to define it in a way that I can ultimately use the STRING clause to string these values together.
Cheers
Tuipeatau
I need to convert an -9(03).9(02) (of value say -001.45) to
a printed value of -1.45
Reason being so I can string these values into a comma delimited file. Leading zeroes are suppressed and no trailing or leading spaces.
If i were to define the field as -ZZ9.99 then the printed value will be - 1.45 with two blank positions between the sign and 1 which is my problem at the moment. Not that I need to define it in a way that I can ultimately use the STRING clause to string these values together.
Cheers
Tuipeatau