|
Home > Archive > dBASE Questions and Answers > August 2005 > Comma Delimited Files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Comma Delimited Files
|
|
| DTindol 2005-08-08, 8:24 pm |
| We use the \'copy to \"XXXXX\" delimited\' command to create several files for use by other systems and vendors. We have encountered a problem where some users cannot accept the file with the end-of-file marker that is in all of the files (\"box\"). Whil
e I can use a text editor and erase the box is there anything I can do to automate that process. Thank you in advance!
| |
| Gerald Lightsey 2005-08-08, 8:24 pm |
| On Mon, 08 Aug 2005 16:30:34 -0400, in the dbase.how-to group, DTindol
said...
> We use the 'copy to \"XXXXX\" delimited' command to create several
> files for use by other systems and vendors. We have encountered
> a problem where some users cannot accept the file with the end-of-file
> marker that is in all of the files (\"box\"). While I can use a text .
> editor and erase the box is there anything I can do to automate that
> process. Thank you in advance!
In dQuery of the latest version, PLUS 2.6, you can export to the file
format "Text File: Comma Delimited with Quotes" with or without field
headers and the old DOS end-of-file character is not in the output.
A couple of other options to "automate" the process are:
1. Write your own routine to output the tables.
2. Write your own routine to remove the end-of-file character from the
output of the copy to command using the file class.
#2 is the quickest and easiest to write and the fastest to run.
Gerald
| |
| Sébastien de Breuck 2005-08-10, 3:24 am |
| DTindol Wrote:
> We use the 'copy to \"XXXXX\" delimited' command to create several files for use by other systems and vendors. We have encountered a problem where some users cannot accept the file with the end-of-file marker that is in all of the files (\"box\"). Wh
ile I can use a text editor and erase the box is there anything I can do to automate that process. Thank you in advance!
*****
Maybe you can use the exportdata.wfm of Ken Mayer. You will find it in the dUFLP on his website http://www.goldenstag.net/dbase/
Sébastien
| |
|
| HI,
If this is all done in a program, then create a functionj to open the file
with the file class, either seek for the characture or move to the end of
the file and delete it, save the file.
Robert
"DTindol" <hrt@compassbnk.com> wrote in message
news:oqGTHgFnFHA.1768@news-server...
> We use the 'copy to \"XXXXX\" delimited' command to create several files
for use by other systems and vendors. We have encountered a problem where
some users cannot accept the file with the end-of-file marker that is in all
of the files (\"box\"). While I can use a text editor and erase the box is
there anything I can do to automate that process. Thank you in advance!
|
|
|
|
|