Hello!

I recieved a wierd ASCII file from a client of ours. He wants to have this ASCII file converted to a database format so I can make a VFP 6 application for him.

The first line looks something like this:

1 't Casteelken St.Pe s & Paulusstraat 2 8800 RUMBEKE 051/20.98.11 051/22.10.63

All in one line (not several as in this message).

The second line:
2 't Meubelhof Rijksweg 477 3630 MAASMECHELE 089/76.19.23 089/77.18.16

That it. But there isn't a real concistincy in it. It would be easy that all the fields would have a fixed length in every line. Not the case. On one line it's 20 and the other is 30 for instance.

It's also quite a big file so editing it to proper format is to much work.

Are there any good utilities to read wierd ASCII formats and convert them to a normal (.dbf for instance) format?

Anyway to program something like this in VFP?

Thanks for your feedback!