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:
00591269
Vues:
34
BTW, forgot to mention, that this file is huge. It could not be opened by WordPad. I'm trying with Excel now, but it seems like it hangs up... VFP opens file with no problems.

>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...
>
>Thanks a lot in advance.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform