Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 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: 143305 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Monday, August 27, 2007 4:31:14 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

Derek

To remove LF from the file

After
COPY TO YourFile

do

lcStr=FileToStr(YourFile)
lcStr=CHRTRAN(lcStr,chr(10),'')
StrToFile(lcStr,YourFile)

Regards
Tushar

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