| T O P I C R E V I E W |
| peter.cook |
Posted - 01/15/2004 : 06:02:32 AM
Hi,
Is there an option to NOT export the missing value '--' for worksheets? If not, please can you consider this as a request?
Currently I have to convert all columns to text then remove '--'.
Cheers,
Pete
|
| 4 L A T E S T R E P L I E S (Newest First) |
| peter.cook |
Posted - 02/16/2004 : 04:03:58 AM
Hi CP,
Thanks for reply.
This simple extra functionality saves me a lot of grief and code and answers most problems I've had with '--' missing value symbol. I'm glad I found out now!
Cheers,
pete
Edited by - peter.cook on 02/16/2004 04:04:50 AM |
| cpyang |
Posted - 02/15/2004 : 3:22:12 PM
This is already possible in Origin7.5, just that this feature was not put into the GUI. To use this feature,
1. use OC, there is WKS_EXPORT_MISSING_AS_BLANK bit, but that was not in the Worksheet class ExportASCII function documentation. You can find this in oc_const.h
2. Modify file.ogs, find [ASCIIExport] and add the following line
wks.export.cntrl += hex(10);
before the line
save -WH %H %B%A;
CP
Edited by - cpyang on 02/15/2004 3:25:06 PM |
| peter.cook |
Posted - 02/13/2004 : 03:47:04 AM
Thanks Laurie,
This would be very useful...I've always had problems with the '--'. Clearly users might not (in our case don't) want to see '--' in exported data.
Cheers,
Pete
|
| Laurie |
Posted - 02/12/2004 : 2:50:23 PM
Hi Peter,
I've tracked the suggestion as QA-5984.
Laurie
OriginLab Technical Support |
