Differences in export function results
Kenneth Brody
kenbrody at spamcop.net
Fri May 15 09:15:55 PDT 2009
GCC Consulting wrote:
>
>> -----Original Message-----
>> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
>> Sent: Friday, May 15, 2009 11:39 AM
>> To: gccconsulting at comcast.net
>> Cc: filePro Mailing List
>> Subject: Re: Differences in export function results
>>
>> GCC Consulting wrote:
>> [...]
>>>>>> What, exactly, ends up in the export file?
>> [...]
>>>> What, exactly, ends up in the export file?
>> [...]
>>> Note: Below is the actual code, Blank is a long variable set to a null
> value.
>> [...]
>>> If reset date and/or footage change missing, expected datys ended in
> wrong
>> place, shift one column right.
>>
>> What, exactly, ends up in the export file?
>
> From field(21) to field(26) everything would get pushed over 1 column
> location. What I found was the if the field(s) were blank and I was quoting
> the value, the double quote caused everything to be shifted right. Testing
> for a blank value and not exporting "" put everything in the correct column.
>
> The value in field 40 of the file was not quoted, Excel imported the value
> into 2 columns, one with a numeric day and a 3 letter month. The next
> column had the numeric values. However, this shifted everything right.
What, exactly, ends up in the export file?
[...]
--
Kenneth Brody
More information about the Filepro-list
mailing list