Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting wierd ASCII file to readable database format
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00215249
Message ID:
00215294
Vues:
34
Your lines look even wierd in the UT editor. So i guess the delimiter is a TAB.
Try using the Import Wizard from VFP with TAB as delimiter.

>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!
Stefan
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform