| Author |
 Topic  |
|
|
peter.cook
UK
356 Posts |
 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
|
|
|
Laurie
USA
404 Posts |
Posted - 02/12/2004 : 2:50:23 PM
|
Hi Peter,
I've tracked the suggestion as QA-5984.
Laurie
OriginLab Technical Support |
 |
|
|
peter.cook
UK
356 Posts |
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
|
|
|
|
cpyang
USA
1406 Posts |
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
UK
356 Posts |
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 |
|
|
| |
Topic |
|
|
|
Exporting missing value data