I'm trying to build a delimited text file to feed someone else's (non-Progress) program and they need the leading and trailing zeroes displayed in the decimal fields.
I tried formats on the variable definition and export. Is there an easy way to do this? (This is just simple logic to test, the real table has a many decimal and character fields) I don't want the number quoted.
OUTPUT TO test.txt.
DEF VAR igr AS DECI FORMAT "999.999".
DEF VAR txt AS CHAR FORMAT "x(20)".
ASSIGN igr = 1.1 txt = "yack, yack, yack".
export DELIMITER ";" igr FORMAT "999.999" txt.
I want the output to be:
001.100;"yack, yack, yack"
but I get
1.1;"yack, yack, yack"
Thanks in advance.
I tried formats on the variable definition and export. Is there an easy way to do this? (This is just simple logic to test, the real table has a many decimal and character fields) I don't want the number quoted.
OUTPUT TO test.txt.
DEF VAR igr AS DECI FORMAT "999.999".
DEF VAR txt AS CHAR FORMAT "x(20)".
ASSIGN igr = 1.1 txt = "yack, yack, yack".
export DELIMITER ";" igr FORMAT "999.999" txt.
I want the output to be:
001.100;"yack, yack, yack"
but I get
1.1;"yack, yack, yack"
Thanks in advance.