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 --> |
If you're willing to make it a two step process, use DELIMITED WITH (some character you KNOW isn't in the data) and then use STRTOFILE(STRTRAN(FILETOSTR(filename), (that character) ,'|'), filename). (Hope I got that right...)
Chris.
Précédent
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