And thank you all for comments. I think I've come up with a workable solution
On Sat, Aug 17, 2013 at 10:27 AM, Darren <[email protected]> wrote: > Thanks Kurt will watch that in future. > > Cheers > > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of Kurt @ > VR-FX > Sent: Saturday, 17 August 2013 12:56 AM > To: [email protected] > Subject: Re: Delimited TXT file > > Darren - FYI - if you hit Reply-To-All, you are actually sending out > Duplicates of your Reply - as its going to the ProFox list AND the > ProFoxTech List (that's the version of the list that does NOT include OT > postings)! Just an FYI... > > -K- > > > On 8/16/2013 6:07 AM, Darren wrote: > > True enough however the output is different so a little more work to > > handle that - depends on how critical output format is. > > > > e.g. > > CREATE CURSOR w_test (fld1 N(10,2), fld2 c(30), fld3 c(40), fld4 T, > > fld5 I, > > fld6 L, fld7 d) > > > > Delimited: > > 1.00,"1 ","1 > > ",16/08/2013 7:49:11 PM,35,.T.,17/08/2013 > > > > Textmerge > > 1.00, 1,1,16/08/2013 7:49:11 PM,35,T,17/08/2013 > > > > If file is small (less than the string limit) the easiest is possibly: > > (It is also faster than textmerge by about 40%) > > > > COPY TO c:\temp\myfile.tmp TYPE DELIMITED STRTOFILE("First Line Text" > > + CHR(13) + FILETOSTR("c:\temp\myfile.tmp"), > > "c:\temp\myfile.txt") > > ERASE c:\temp\myfile.tmp > > > > > > -----Original Message----- > > From: ProfoxTech [mailto:[email protected]] On Behalf Of > > Alan Bourke > > Sent: Friday, 16 August 2013 6:20 PM > > To: [email protected] > > Subject: Re: Delimited TXT file > > > > No need to complicate things with fopen() and low-level IO for most > > writing strings to a file tasks. > > > > set textmerge on noshow > > set textmerge to myfile.txt > > \ Here's my first line that the client wants. > > select mytable > > scan > > > > \<<field1>>,<<field2>>,<<field3>>,<<field4>>,<<field5>>,<<field6>>,<<f > > ield7> > > endscan > > set textmerge off > > set textmerge to > > [excessive quoting removed by server] _______________________________________________ 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/cag1nny-gfebam802fispq2qdpto6avzgqrhhs9n02hz1-bh...@mail.gmail.com ** 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.
