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