You're welcome.
>Hi Tore
>Yep..that seems to do it
>Many thanks
>regards
>Gerard
>
>
>>This is one of the syntaxes I always forget, so I had to give it quite a few tries before I succeeded.
>>
>>copy mytext.txt deli with "" with char |
>>
>>>Hi
>>>I have a table with say Joe Bloggs, Boston,USA (3 fields)
>>>I want to export as follows:
>>>Joe Bloggs|Boston|USA (i.e. without blanks and a '|' as the delimiter..but cant seem to do exactly that
>>>
>>>If I try
>>>Copy to MyText Delimited with ' ' with Character '|' (Space between the 2 single quotes)
>>> It adds a Space before and after each field Joe Bloggs | Boston | USA |
>>>
>>>Copy to MyText Delimited with '' with Character '|' (Nothing between the 2 single quotes)
>>> It adds single quotes before and after each field 'Joe Bloggs'|'Boston'|'USA'|
>>>
>>>Copy to MyText with Character '|'
>>>....Gives a syntax error
>>>
>>>
>>>Anybody know if I can use the Copy to to o/p fields delimited with a '|' but without blanks ??
>>>
>>>Tia
>>>Gerard