Subject Re: importing text file programmatically From Emeka Ossai <megameks@yahoo.com> Date Tue, 08 Feb 2022 10:34:16 -0500 Newsgroups dbase.getting-started Attachment(s) custodian0207.txt, custodian.DBF Oh thank you Mervyn I have attached the files Thank you. Emeka Mervyn Bick Wrote: > On 2022/02/08 16:22, Emeka Ossai wrote: > > Hi all, > > > > lHow else can I import text file to allign well on dbase table. The below syntax is not aligning properly. > > > > what am using > > > > use custodian > > fileName = getFile(\\\"*.txt\\\", \\\"Select text format file...PLS BE SURE THIS IS TRADING TXT FORMAT\\\") > > APPEND FROM &filename sdf > > > > Emeka > > Although there should be no fomatting in a .txt plain text file it > sounds as if the text in the text file is written using a proportional > font. > > Unless there is confidential information in the text files please post a > file here together wit the structure of custodian.dbf. > > Mervyn. UBNOM  2 130924079  32113306INTBREW                     1    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27644633  20220207 UBNOM  2 130924079  32113306INTBREW                     1    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27645931  20220207 UBNOM  2 130924079  32113306INTBREW                     7    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27644631  20220207 UBNOM  2 130924079  32113306INTBREW                    14    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27644632  20220207 UBNOM  2 130924079  32113306INTBREW                    22    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646555  20220207 UBNOM  2 130924079  32113306INTBREW                    45    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27645987  20220207 UBNOM  2 130924079  32113306INTBREW                    50    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27644738  20220207 UBNOM  2 130924079  32113306INTBREW                   400    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646718  20220207 UBNOM  2 130924079  32113306INTBREW                   800    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27644768  20220207 UBNOM  2 130924079  32113306INTBREW                  1000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27645774  20220207 UBNOM  2 130924079  32113306INTBREW                  1000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27644872  20220207 UBNOM  2 130924079  32113306INTBREW                  1250    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646532  20220207 UBNOM  2 130924079  32113306INTBREW                  2000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27644951  20220207 UBNOM  2 130924079  32113306INTBREW                  2000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646571  20220207 UBNOM  2 130924079  32113306INTBREW                  2200    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27647548  20220207 UBNOM  2 130924079  32113306INTBREW                  5000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646575  20220207 UBNOM  2 130924079  32113306INTBREW                  5000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646574  20220207 UBNOM  2 130924079  32113306INTBREW                  8000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27647333  20220207 UBNOM  2 130924079  32113306INTBREW                 10000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27647023  20220207 UBNOM  2 130924079  32113306INTBREW                 10000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646560  20220207 UBNOM  2 130924079  32113306INTBREW                 10000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646585  20220207 UBNOM  2 130924079  32113306INTBREW                 10000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646584  20220207 UBNOM  2 130924079  32113306INTBREW                 15000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646488  20220207 UBNOM  2 130924079  32113306INTBREW                 20000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646570  20220207 UBNOM  2 130924079  32113306INTBREW                 51707    5.05RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27649690  20220207 UBNOM  2 130924079  32113306INTBREW                 55000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646695  20220207 UBNOM  2 130924079  32113306INTBREW                 96500    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646341  20220207 UBNOM  2 130924079  32113306INTBREW                118000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646522  20220207 UBNOM  2 130924079  32113306INTBREW                200000    5.05RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27649659  20220207 UBNOM  2 130924079  32113306INTBREW                300000    5.30RIVERS STATE MIN OF FIN INCORPORATED-TRATLFS   27646741  20220207