bject: Re: exporting to text delimited
On Wed, Oct 30, 2013, at 03:34 AM, Dan Covill wrote:
> On 10/29/13 07:31 PM, Gary Jeurink wrote:
> > COPY TO c:\alldat2\special\tmppfbstats.txt FOR pfbstats2.year=2013
> >
> >FIELDS Pfbstats2.tmid, Pfbstats2.year, ...
>
> use
013 10:35 PM
To: profox@leafe.com
Subject: Re: exporting to text delimited
On 10/29/13 07:31 PM, Gary Jeurink wrote:
> COPY TO c:\alldat2\special\tmppfbstats.txt FOR pfbstats2.year=2013
>
>FIELDS Pfbstats2.tmid, Pfbstats2.year, ...
use FIELDS Pfbstats2.tmid, str(Pfbstats2.year,4) as C
On Wed, Oct 30, 2013, at 03:34 AM, Dan Covill wrote:
> On 10/29/13 07:31 PM, Gary Jeurink wrote:
> > COPY TO c:\alldat2\special\tmppfbstats.txt FOR pfbstats2.year=2013
> >
> >FIELDS Pfbstats2.tmid, Pfbstats2.year, ...
>
> use FIELDS Pfbstats2.tmid, str(Pfbstats2.year,4) as Cyear, . etc
>
On 10/29/13 07:31 PM, Gary Jeurink wrote:
COPY TO c:\alldat2\special\tmppfbstats.txt FOR pfbstats2.year=2013
FIELDS Pfbstats2.tmid, Pfbstats2.year, ...
use FIELDS Pfbstats2.tmid, str(Pfbstats2.year,4) as Cyear, . etc
Then the DELIMITED will put quotes around it.
Dan
I'm rusty, but it is probably dtoc("pfbstats2.year")
You might have to do something along these lines
alltrim(dtoc("pfbstats2.year"))
Ltrim() will work as well, or rtrim() depending on which way you need to go
As for the rest, I don't know what your fields are, but you will need to
build it
M_Y
5 matches
Mail list logo