Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY TO & APPEND FROM Problem
Message
 
 
To
02/03/2001 15:12:09
Rebecca Stottlemire
Kansas State Department of Commerce
Topeka, Kansas, United States
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00481531
Message ID:
00481578
Views:
13
>I have a simple import and export screen that uses COPY TO to create either a tab delimited or SDF file, and APPEND FROM either tab delimited or SDF. Everything works file with the SDF files for both importing and exporting files, but on the DELIMITED WITH TAB file that is written out, VFP 6.0 puts quotes around the character fields. Thus, when importing the same file, using APPEND FROM DELIMITED WITH TAB, the quotes screw up the append.
>
>Is there a way I can get rid of the quotes in the file that is written out, or else get it to ignore the quotes on the APPEND FROM???
>
>I haven't been able to figure this one out. Thanks loads for all of your help!
>Becky

Hi Becky,

Have you changed your last name? :) I also could not find a VFP native command to produce file without double quotes, so originally I used
          * Remove double quotes
          llReturn=strtofile(strtran(filetostr(lcFileName),["],''), lcSendFileName)
This technique doesn't work on huge files (more than 16MB), so I did it through low-level functions. Then I thought, may be it's better to write a C fll to do this. I exchanged ideas here in UT (about month ago) and I also sent private messages to Cetin Basoz, who finally wrote the C++ code for me :) So, I produced a fll and this fll seems to work faster, than my original technique.

So, if your files are huge, I'll send you the code and instructions.

BTW, Cetin, do you think, it would be a great addition to a FAQ section?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform