Subject Re: importing text file programmatically
From Emeka Ossai <megameks@yahoo.com>
Date Thu, 10 Feb 2022 04:12:16 -0500
Newsgroups dbase.getting-started


Ok Mervyn,

THANK YOU SO MUCH

Emeka

Mervyn Bick Wrote:

> On 2022/02/08 23:53, Emeka Ossai wrote:
> > Hi Mervyn,
> >
> > The problem now is that same dbf structure, same command but could not append another text file of same structure correctly.
> >
> > Please help me append the attached text file if you can detect the error.
> >
>
> The problem is that the second text file is NOT the same structure as
> the first one.
>
> custodian0207.txt
> UBNOM  2 130924079  32113306INTBREW.......
>
> custodian0402.txt
> UBNOM  2  130924079  32113306INTBREW.......
>
> There is an extra space between the data for field2 and field3 in
> custodian0402.txt.
>
> The SDF format relies on data for each field occupying exactly the same
> position in a fixed length line of text for each record.
>
> Mervyn.
>
>