Versions des environnements
Network:
Windows 2008 Server
>My file contains
>
>A records max length 254 characters write as a single line on the text file
>
>B records 2 lines of max 254 characters which I want to write as a single line of text
>
>The text file is to be comma delimited with " around the text
>
>Any ideas? has it got anything to do with carriage return / line feed characters?
Start by experimenting with the various versions of COPY TO, like TYPE DELIMITED and TYPE SDF, to see how close that gets you. Once you use that to get the data items formatted as desired, probably use FileToStr() to read it back in, ALINES() to break it up and then a loop to combine the two lines you want into one. Finally, StrToFile() to write it back out.
If I've totally misunderstood your needs, show us a few sample records and the desired result.
Tamar
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