Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Michael Milling
  Where is Michael Milling?
 Mobile
 Alabama - United States
 Michael Milling
 To: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 Tags
Subject: RE: Tab delimited file to ALINES
Thread ID: 395556 Message ID: 395569 # Views: 35 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Wednesday, January 15, 2014 10:06:45 PM         
   


> >
> >
> > I tried it, but it didn't work. I think it was close though because the error was "Function Name is Missing"
> >
> >
> >
ALINES(aTemp, FILETOSTR("File" DELIMITED WITH TAB)) &&Didn't work

>
>
>
> The FileToStr() syntax is wrong, but the "Append From" command does not work with Memo columns anyway.
>
> You could use "LLF" functions, something like
>
lnHandle = FOPEN(m.lcFile)
> Do While Not FEof(m.lnHandle)
>     lcLine = FGETS(m.lnHandle, 8192)
>     ALine(laLines, STRTRAN(m.lcLine, CHR(9), CHR(13)+CHR(10)))
>     && and so forth
> 

>
> Or perhaps use FileToStr() to get the entire content, and then use ALines() twice to get the lines first and then the "words" from each line, something like
>
> lcContent = STRTOFILE(m.lcFile)
> ALINES(laLines, m.lcContent)
> ALINES(laWords, laLines[1], 0, CHR(9))
> ? laWords[1] && and so on
> 

>
>
>
> hth
> -Stefan

Thank you for the reply. I am on VFP 6, so the additional arguments in ALINES do not work with this version I belive.

ENTIRE THREAD

Tab delimited file to ALINES Posted by Michael Milling @ 1/15/2014 9:01:27 PM
RE: Tab delimited file to ALINES Posted by Ali Koumaiha @ 1/15/2014 9:18:14 PM
RE: Tab delimited file to ALINES Posted by Michael Milling @ 1/15/2014 9:23:14 PM
RE: Tab delimited file to ALINES Posted by Vilhelm-Ion Praisach @ 1/15/2014 9:32:43 PM
RE: Tab delimited file to ALINES Posted by Stefan Wuebbe @ 1/15/2014 9:44:18 PM
RE: Tab delimited file to ALINES Posted by Michael Milling @ 1/15/2014 10:06:45 PM
RE: Tab delimited file to ALINES Posted by Vilhelm-Ion Praisach @ 1/16/2014 5:24:24 AM
RE: Tab delimited file to ALINES Posted by Michael Milling @ 1/16/2014 8:12:37 PM
RE: Tab delimited file to ALINES Posted by Stefan Wuebbe @ 1/16/2014 6:04:11 AM
RE: Tab delimited file to ALINES Posted by Anders Altberg @ 1/16/2014 12:04:51 AM