I use lotus export a lot to transfer data for statistical analysis and I continue to have a lot of trouble getting numeric data (other than INTEGER) to format correctly in arev and the lotus file:

FLOAT - exports as text rather than numeric data

DECIMAL - scaling works correctly within AREV but is ignored in creating the lotus file; e.g. with MD20, 1.23456 appears in AREV as 1.23, but in the lotus file as 0.0123456.

The only workaround I've been able to come up with is using MD without any paramters which types the lotus data as numeric and displays the decimal correctly both in arev and the lotus file; however, this means I can't control the number of decimal places to be shown in RLIST with out adding explicit formatting in the command.

I've looked at the source that I have for lotus export and I can see that the code is trying to deal with scaling. Aaron said to check the source from arev 2.12–is that the code that is still being used for arev export in 3.11? Is anyone familiar enough with the code to tell me how to fix the scaling problem? Does anyone else get the same "behavior"? Thanks for any help you can give me.

David

If you are having trouble, perhaps you could

(a) write symbolics to format your data in say comma delimited form,

pre formatted to the correct number of decimal places etc.

then

(b) read the comma delimited file into Lotus.

Steve

I found it easier to just manipulate the data in the spreadsheet. You can easily convert the text data to numerics using formulas.

I actually haven't found a very easy way to convert text to numeric format in Excel–I finally was able to create a macro that does it for a blocked column, but still have to figure out how to make the macro "global" so I can run it on any file.

Thanks for the work-around suggestions–I'd still be interested in fixing the export function itself if that were possible.

View this thread on the forum...