Differences in export function results
Kenneth Brody
kenbrody at spamcop.net
Fri May 15 07:51:33 PDT 2009
GCC Consulting wrote:
[...]
>> What, exactly, ends up in the export file?
>
> Export without the quote gives a date-month(3 letters) in that column
> location and the actual value in the next column position.
>
> When quoted and a value present the value is properly imported into Excel
> and all other values are in the correct location.
>
> As I indicated below, I needed to test for a blank. If blank export a null
> value with no quotes.
What, exactly, ends up in the export file?
[...]
>>> There are definite differences between the 2 functions.
>>>
>>> export ascii shipdet =c:\shipdet r=\n f=, -x
>>>
>>> export word shipdet=c:\shipdet
>>>
>>> May not give the same results.
>> Why would you expect them to give the same results, when they're not
>> equivalent?
>
> Didn't expect the same results. I wanted to see which function would give
> the desired results. Export word worked fine once I tested for an blanks
> and made sure I didn't export the double quotes.
Okay. The wording made me think that you didn't expect any differences.
[...]
In any case, as I said, it sounds like an Excel issue that you're trying to
work around, by coaxing filePro into generating what Excel wants. But, you
still haven't shown us what "works" and what "doesn't work", in terms of
actual data.
--
Kenneth Brody
More information about the Filepro-list
mailing list