>>>>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?
>>
>>
>>Hi Nadya,
>>Thanks for the info. I haven't changed my name, only the place where I work.
>>I used to be with the Kansas Department of Education.
>>
>>I do think that the files we will use in the procedure will be very large.
>>Can you send me more info on the C++ code to handle it. Thanks a lot.
>>Becky
>
>Hi Rebecca,
>
>I'll add this info into FAQ, ok? I was hoping Cetin would do it by himself :)
Hi Nadya,
I've looked over the FAQ and think I can work it in. Thanks a lot--that one had
me stumped :o))
Becky
