Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement