csv output

[Ken Cole]

Richard,

If you were on *nix I would be able to provide you with a Perl script that
takes a csv file, a format file, both created from within filePro and then
via a system command runs the Perl script that creates a real xls file with
column formating in it.

Do you have Perl running on any of your Windows machines?

Ken

On Tue, Mar 3, 2009 at 12:14 AM, GCC Consulting
<gccconsulting at comcast.net>wrote:

>  Ken,
>
>
>
> Process runs, file created, Excel started with file loaded.
>
>
>
> I don’t want to add an extra step.  It most likely would be easier, if the
> “ doesn’t work to have them manually change the column edit to text.
>
>
>
> Thanks
>
>
>
> Richard
>
>
>
> *From:* filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com[mailto:
> filepro-list-bounces+gccconsulting <filepro-list-bounces%2Bgccconsulting>=
> comcast.net at lists.celestial.com] *On Behalf Of *Ken Cole
> *Sent:* Sunday, March 01, 2009 6:29 PM
> *To:* Fairlight
> *Cc:* filepro-list at lists.celestial.com
> *Subject:* Re: csv output
>
>
>
> the single inverted comma is the Excel string marker -> '
>
>
>
> However, I don't think excel recognises it in a csv file as anuthing else
> than a valid character.
>
>
>
> Somethimes it is better to define the file name with .dat and Excel will
> not try to auto import it but starts an import wizard in which yo can set
> column data types  so you could then set the type for this column to text
> and the problem would not occur.
>
>
>
> Ken
>
> On Sat, Feb 28, 2009 at 4:01 AM, Fairlight <fairlite at fairlite.com> wrote:
>
> With neither thought nor caution, Richard Kreiss blurted:
>
> > Have a small problem and I am sure one of you can answer this.
> >
> > I am outputting a value 6 and a letter.  If the value is either an A or
> P,
> > when excel reads in the value, it converts to a time.
> >
> > Any idea how to avoid this?
>
> If memory serves, preceed your value with a single doublequote to have it
> taken as a string literal.
>
> I'm assuming you mean it's being converted in Excel.  If not, ignore the
> above.
>
> 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"
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20090303/238c3a5d/attachment-0001.html