Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Text files with different structures and delimiters
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00591251
Message ID:
00591269
Views:
33
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
Previous
Reply
Map
View

Click here to load this message in the networking platform