Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import command???
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01498434
Message ID:
01498461
Vues:
45
>>>>I have a .txt file that has a few fields delimited by a ~
>>>>
>>>>What is the syntax to import that .txt file into a cursor (or a temp table) ??
>>>
>>>APPEND FROM should give you what you need (you can experiment with the WITH DELIMITER or WITH CHARACTER clauses).
>>
>>I tried this:
>>
>>APPEND FROM myfile.txt DELIMITED WITH '~'
>>
>>...but all I get is data in the 1st column (there are 14).
>>
>>same thing happens if I try this:
>>
>>APPEND FROM myfile.txt FIELDS column1, column2 delimited WITH '~'
>
>How about ... DELIMITED WITH CHARACTER ~ (note no quotes around the tilde)

Interesting. So this fails:

APPEND FROM myfile.txt FIELDS column1, column2 DELIMITED WITH '~'

and this works:

APPEND FROM myfile.txt FIELDS column1, column2 DELIMITED WITH CHARACTER

Not sure what the heck the difference is....but whaaatever - it works. Thanks!
ICQ 10556 (ya), 254117
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform