General information
Category:
Coding, syntax & commands
Title:
Copy to Txt file with just a delimiter
Environment versions
Network:
Windows 2008 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only