David,

Thanks!, those few lines of code did the job very nicely, although I do have VFP 6, this one project is being done in 5, and although I've proposed to move up to 6, the other developer haven't had too much luck with VFP6 on his machine, u know, toolbar issues, query designer bugs, report builder misbehaviour, blah, blah, blah so I guess for now we'll have to use our 20 line code routine, unless the latest version of Visual Studio which we get every month, has a fix for all this stuff.

Anyway, sorry about my whining and thanks again, I will definitely use the tip for my personal projects




>Gil,
>
>Export the file like you are now, then
>x = filetostr( "TheFile.txt" )
>y = chrtran( x, ["], [] )
>strtofile( y, "TheFile.txt" )
>
>unless the file is huge this will work pretty fast. If you don't have VFP6 with these functions append the file into a temp cursor memo field.
>
>>I have a table with numeric, integer, character, and date fields and it's mandatory to create an export file of type tab delimited.
>>
>>Using the COPY TO filename DELIMITED WITH TAB is fine and dandy, except for the fact that all character type fields get exported with doble quotes(") at the beginning and end of each value. The accounting package that needs to import these values will not understand them correctly since it takes no "
>>
>>Now, I tried every possible combination of syntax values and everything else until the only way I could get it to work was with some spaghetti code that my buddy and I wrote for it.