Quotation marks are missing from export

[pablo.vivanco]

Hi, any help is appreciated (sorry about my english)

Openedge 11.7.19

I have a report that exports a temp-table

OUTPUT TO c:\temp\report.csv.
FOR EACH t-conc_timb NO-LOCK:
EXPORT DELIMITER ',' t-conc_timb.
END.
OUTPUT CLOSE.


But in some user computers the output file doesnt include the quotation marks for the fields, so when is opened in excel everything is just in one column




In other computers it is generated correctly, every field is enclosed in quotation marks, so it can be opened fine in excel, every field in separate column:



Any idea what could be the problem?

Thank you!

 

[peterjudge]

The output that you are showing is for different tables I assume. Are you sure they use the same program to write the data to disk?
The first example might be using a PUT or DISPLAY statement, and not the EXPORT statement.

 

[pablo.vivanco]

The output that you are showing is for different tables I assume. Are you sure they use the same program to write the data to disk?
The first example might be using a PUT or DISPLAY statement, and not the EXPORT statement.

I checked again and as you stated, the one without the quotation marks is using "PUT UNFORMATTED" and the other one is using EXPORT, is it possible to close or delete this thead?

thank you

 

[TomBascom]

Actually, I think it is good to keep it visible. You asked a question in good faith, showed code and data relevant to the problem, got an answer quickly, and confirmed that the reason was as Peter suggested. That is a very nice example of “doing it right”! We can all learn from that.

 

[jdpjamesp]

Yes I agree. It's a great example of how this forum should work. And it documents the difference between PUT and EXPORT nicely.

 

[peterjudge]

I checked again and as you stated, the one without the quotation marks is using "PUT UNFORMATTED" and the other one is using EXPORT, is it possible to close or delete this thead?

thank you

If you want to continue using the PUT statement and want the data quoted, look at the QUOTER function.

For you old 'uns here, is there any other example you can think of of a language function being 'imported' from a C program that Progress ships?