Subject Re: importing text file programmatically From Mervyn Bick <invalid@invalid.invalid> Date Tue, 8 Feb 2022 22:24:31 +0200 Newsgroups dbase.getting-started On 2022/02/08 22:17, Mervyn Bick wrote: > On 2022/02/08 17:34, Emeka Ossai wrote: >> Oh thank you Mervyn >> >> I have attached the files > ....... > Attached is a little program to append from the text file and then > populate the ddate and cdate fields. > > Mervyn. Oops.  A line got left in by mistake.  It doesn't work so it does nothing.  Comment it out or delete it. scan //   cDate = ltrim(rtrim(field10))     replace ddate with new date(val(substr(ltrim(field10),1,4)),val(substr(ltrim(field10),5,2))-1,val(substr(ltrim(field10),7,2)))     replace cdate with dtoc(ddate) endscan Mervyn.