General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
Hi Doris. Thanks for your reply
When I do :
copy to MyText delimited with character '|' ........ I get each fields separated by | and DoubleQuote as in "JoeBloggs"|"Boston"|"USA"|
copy to MyText delimitied with '|' ... I get each field enclosed in | | and separated by a comma as in |Joe Bloggs|,|Boston|,|USA|
Still cannot get anything t produce ----> Joe Bloggs|Boston|USA| i.e. Each field separated by --> |
Regards,
Gerard
>copy to MyText delimited with character '|' works for me
>that or
>copy to MyText delimitied with '|'
>
>
>>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
Previous
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