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