Thanks, I figured it would be str() or something more specific. This will be the one I try first. Since it's a text dump, I don't think I'll need the as Cyear.
Gary Jeurink -----Original Message----- From: Dan Covill [mailto:[email protected]] Sent: Tuesday, October 29, 2013 10:35 PM To: [email protected] 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 Cyear, . etc Then the DELIMITED will put quotes around it. Dan _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/B1A4AEFBD44A4BC4A07FD32C8506A87B@OwnerPC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
