Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Vilhelm-Ion Praisach
  Where is Vilhelm-Ion Praisach?
 Resita
 Romania
 Vilhelm-Ion Praisach
 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: 395563 # Views: 50 # Ratings: 4
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Wednesday, January 15, 2014 9:32:43 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



FOR i = 1 TO ALINES(aTemp, FILETOSTR("file with path")) &&Delimited somehow?
     =ALINES(aTemp2, aTemp[i],CHR(9))
     INSERT INTO cTemp(example1, example2, oldMemo, newMemo) VALUES (aTemp2[1], aTemp2[2], aTemp2[3], aTemp2[4])
ENDFOR


or

FOR i = 1 TO ALINES(aTemp, FILETOSTR("file with path"),CHR(13),CHR(9)) STEP 4 &&Delimited somehow?
 INSERT INTO cTemp(example1, example2, oldMemo, newMemo) VALUES (aTemp[i], aTemp[i+1], aTemp[i+2], aTemp[i+3])
ENDFOR




My respects

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