| 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.
|
|