>>>I am trying to produce a delimited text file
>>>
>>>COPY TO d:\eudora\attachb\testa.csv DELIMITED WITH "~"
>>>
>>>But that puts the ~ before and after every field so my file looks like
>>>
>>>~Colin New York Inc~ ~14th Floor~ ~World Trade Center~ ~New York~ ~NY10001~ ~Colin Northway~ ~0016468424105~ ~~ ~colin@colin-northway.com~ ~COL999~ ~816227~ ~~
>>>
>>>
>>>What is the correct instruction?
>>
>>sorry slight brainstorm now am using copy to d:\eudora\attachb\testa.csv Type Delimited With Character ~ BUT
>>
>>"Colin New York Inc"~"14th Floor"~"World Trade Center"~ I don't want the quotes how do I get rid of them?
>
>Try
>

>COPY TO test.txt DELIMITED WITH "" WITH CHARACTER ~

You are a star - thanks - Shabbat shalom