Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 Tags
Subject: RE: problem with text file generated- urgent
Thread ID: 143090 Message ID: 143300 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Monday, August 27, 2007 3:59:29 PM         
   


> >
> > CR+LF are included in all text formats as end of line marker.
> > I remember one ERP (I think it was SUSYSTEMS but I could be wrong) didn't liked CRLF at the end of the last line. Others wanted EOF (Ctrl+Z) marker at the end of file. So you have two choices
> >
> > 1. Ask developers of that application what they don't like in your file.
> > 2. Ask your user to send you a file which are imported correctly in that application and see the difference.
> >
> >
> >
> > -----------------
> > Borislav Borissov
> >
> > Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> > The only thing normal about database guys is their tables.
>
>
> Ive been asked to use carriage return at the end of each line of the record,.
>
> Please assist with an example.
> This means we need to change the
copy to ....sdf format

>
> Thanks


As I said ALL exports have CRLF at the end of the line, only the last row hasn't. If you are asked to put CRLF at the end of the file open it and just add CRLF as a last two chars.

-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

problem with text file generated- urgent Posted by DEREK DODOO @ 8/24/2007 7:40:55 PM
RE: problem with text file generated Posted by Pamela Thalacker @ 8/24/2007 7:47:45 PM
RE: problem with text file generated Posted by DEREK DODOO @ 8/24/2007 7:59:28 PM
RE: problem with text file generated Posted by Barbara Peisch @ 8/24/2007 8:34:06 PM
RE: problem with text file generated Posted by Pamela Thalacker @ 8/24/2007 9:07:40 PM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/24/2007 9:02:09 PM
RE: problem with text file generated- urgent Posted by DEREK DODOO @ 8/25/2007 6:21:19 AM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/25/2007 8:06:46 AM
RE: problem with text file generated- urgent Posted by DEREK DODOO @ 8/27/2007 3:22:22 PM
RE: problem with text file generated- urgent Posted by Borislav Borissov @ 8/27/2007 3:59:29 PM
RE: problem with text file generated- urgent Posted by tushar @ 8/27/2007 4:31:14 PM
RE: problem with text file generated- urgent Posted by tushar @ 8/25/2007 8:52:10 AM
RE: problem with text file generated- urgent Posted by Cetin Basoz @ 8/24/2007 9:28:50 PM