RE: exporting to text delimited

2013-10-30 Thread Gary Jeurink
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

RE: exporting to text delimited

2013-10-30 Thread Gary Jeurink
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

Re: exporting to text delimited

2013-10-30 Thread Alan Bourke
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 >

Re: exporting to text delimited

2013-10-29 Thread Dan Covill
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

RE: exporting to text delimited

2013-10-29 Thread Virgil Bierschwale
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