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: Vilhelm-Ion Praisach
  Where is Vilhelm-Ion Praisach?
 Resita
 Romania
 Vilhelm-Ion Praisach
 Tags
Subject: RE: Tab delimited file to ALINES
Thread ID: 395556 Message ID: 395663 # Views: 35 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Thursday, January 16, 2014 8:12:37 PM         
   


> >
> > Thank you for the reply. I am on VFP 6, so the additional arguments in ALINES do not work with this version I belive.
>
> You're right, sorry for that. It was late :-)
>
>
FOR i = 1 TO ALINES(aTemp, FILETOSTR("zzzz.txt")) &&Delimited somehow?
> 	lc1=left(aTemp[i],at(chr(9),aTemp[i])-1)
> 	lc2=substr(aTemp[i],at(chr(9),aTemp[i])+1,at(chr(9),aTemp[i],2)-at(chr(9),aTemp[i])-1)
> 	lc3=substr(aTemp[i],at(chr(9),aTemp[i],2)+1,at(chr(9),aTemp[i],3)-at(chr(9),aTemp[i],2)-1)
> 	lc4=substr(aTemp[i],at(chr(9),aTemp[i],3)+1)
> 	INSERT INTO cTemp(example1, example2, oldMemo, newMemo) VALUES (lc1, lc2, lc3, lc4)
> ENDFOR

>
>
> My respects


Awesome. I have never tried to SUBSTR values inside of an array before. I can see this bit of knowledge already helping me out with some other ideas I have.

Thank you very much, Vilhelm!!

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