Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Text files with different structures and delimiters
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00591251
Message ID:
00591275
Vues:
23
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>We received text file (txt extension) from external source. The fields didn't have quotes around them. I think, this file was accompanied with a layout. Now we received another file with different structure and now char fields have quotes around them.
>The first record in both files contains field names.
>
>My question is: how can I automate the process of uploading this file into the table. I have table with a structure, but it doesn't work for the new structure, so I have to re-create it guessing by field names their format. Is it possible to another way? Say, through Excell automation? The table will be created on the fly...
>

Hi Nadya,

It's not direct answer to your question but VFP Import WIzard source code is available under Tools\xsource directory.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform