Progress V 8.3B CHUI
Hello everyone,
I have following problem:
About textfile generated with progress V 8.3b (CHUI).
I export text file from my workfile.Use code like this.
source code.
DEF WORKFILE wk_file .
DEF STREAM ns1.
FOR EACH customer_table NO-LOCK WHERE ......:
CREATE wk_file.
ASSIGN wk_file = customer_table.
END.
OUTPUT STREAM ns1 to VALUE(outputfile).
FOR EACH wk_file .
PUT STREAM ns1 wk_file.field1 FORMAT "X(10)"
wk_file.field2 FORMAT "X(8)"
wk_file.field3 FORMAT "->>>,>>>9.99"
wk_file.field4 FORMAT "X(20)" SKIP.
END.
OUTPUT STREAM ns1 CLOSE.
In my output file,there are some special character "~" in some line of text file. When my end-userd import it to MS Excel they found "~" in head of the line,so they blame me it take a lot of time to delete that special character from textfile.
example text file below.
aaaaaa
bbbbbb
cccccccc
~ddddd
eeeeee
ffffffffffff
Please help,Thanks !!
Hello everyone,
I have following problem:
About textfile generated with progress V 8.3b (CHUI).
I export text file from my workfile.Use code like this.
source code.
DEF WORKFILE wk_file .
DEF STREAM ns1.
FOR EACH customer_table NO-LOCK WHERE ......:
CREATE wk_file.
ASSIGN wk_file = customer_table.
END.
OUTPUT STREAM ns1 to VALUE(outputfile).
FOR EACH wk_file .
PUT STREAM ns1 wk_file.field1 FORMAT "X(10)"
wk_file.field2 FORMAT "X(8)"
wk_file.field3 FORMAT "->>>,>>>9.99"
wk_file.field4 FORMAT "X(20)" SKIP.
END.
OUTPUT STREAM ns1 CLOSE.
In my output file,there are some special character "~" in some line of text file. When my end-userd import it to MS Excel they found "~" in head of the line,so they blame me it take a lot of time to delete that special character from textfile.
example text file below.
aaaaaa
bbbbbb
cccccccc
~ddddd
eeeeee
ffffffffffff
Please help,Thanks !!