NP Darren - as MANY of us over the years has made this mistake - as I
have Also done on occasion...
I suspect you are New here - so, welcome to the Fold!
-K-
On 8/16/2013 6:27 PM, Darren 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/[email protected]
** 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.
