ascii output

Fairlight fairlite at fairlite.com
Tue Aug 11 14:19:16 PDT 2009


Four score and seven years--eh, screw that!
At about Tue, Aug 11, 2009 at 05:12:27PM -0400,
Richard Kreiss blabbed on about:
> Have a problem when export a upc code and bringing it into Excel, the value
> is turned into scientific notation.  Yes, this can easily be corrected by
> applying a number format.
> 
> However, I have tried to export this as a literal and it works fine except I
> get "" at the end.
> 
> My export line reads:
> 
> Del(7)="\""{upc{"\""
> 
> This will yield a value 123456789012""
> 
> How do I get rid of the trailing quotes
> 
> I have used both export word and export ASCII

The " at the beginning of a field denotes to Excel that the field is a
string literal.  But it does -not- get a closing doublequote like you would
find in CSV format.

Try:  Del(7)="\""{upc

mark->
-- 
"I'm not subtle. I'm not pretty, and I'll piss off a lot of people along
the way. But I'll get the job done" --Captain Matthew Gideon, "Crusade"


More information about the Filepro-list mailing list