Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2008 Server
Try COPY TO myText DELIMITED WITH '|'
Chris.
>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