I am trying to create a delimited file using VFP 3.0 and specify a ~ as my delimeter using the following statement.

copy to c:\temp\myfile type delimited with ~

However when I use this statement I end up getting commas between my columns along with the delimeter (ex. ~myfield1~,~myfield2~,~myfield3~, ) I want my data in the delimeted file to look like this myfield1~myfield2~myfield3 . Is there something I am doing wrong? Or is there another way I can create a delimeted file in the format that I need?


Thanks in advance