Subject Re: importing text file programmatically
From Mervyn Bick <invalid@invalid.invalid>
Date Thu, 10 Feb 2022 09:05:00 +0200
Newsgroups dbase.getting-started

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.