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


> > what don't you just append from YourFile.txt delimited with TAB
> >
> > Ez Logic
>
>
> 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

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