Some problem about textfile exported from Progress

rrungrue

New Member
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 !!
 
Hi,

It should be data (in customer-table) related. Does it happen for specific records or for all the records

HTH
V

rrungrue said:
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 !!
 
Back
Top