Environment versions
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
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