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