>Hi,
> I am trying to make a text file that is delimited by ~ but when I use the following command I have a problem.
>copy to c:\temp\mytext.txt delimited with ~
>
>When I go to open this in Excel and specify my delimeter I end up with seeing a ~ on each side of my data. I only need a ~ between each column (ex. account~date~testing). Can anyone help?
>
>Thanks in advance.
>Todd
Try DELIMITED WITH CHARACTER '~'
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope