[filePro Alpha Mailing List] ascii output

[Chris Henschen]

> -----Original Message-----
> From: alpha-bounces at fptechforum.com [mailto:alpha-
> bounces at fptechforum.com] On Behalf Of Richard Kreiss
> Sent: Tuesday, August 11, 2009 5:12 PM
> To: 'filePro Alpha Mailing List'; filepro-list at lists.celestial.com
> Subject: Re: [filePro Alpha Mailing List] ascii output
> 
> 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
> 
> 
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
> 

Not sure how your export command is setup, but if you are exporting a CSV
format the quote would be there to reflect it a text field.  If you don't
mind using JSFILE command you could have more control over the output.  Ex:

Jsfile :CR "/tmp/file.csv"
Jsfile :TX ""{1{",\"field1\","\""{upc{"\""
Jsfile :CR-