Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Comma Delimited File
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00484983
Message ID:
00485153
Vues:
10
>>You can SET LIBRARY TO Foxtools and use words() and wordnum() and nextword() functions afterwords.
>>
>>>Hi,
>>>Is there any way to convert a comma delimited file to an array?, Really >appreciate it !
>>
>>>Thanks,
>
>You can use ALINES function:
>
lcString = "One,Two,Three,..."
>lncnt = ALINES(laList, STRTRAN(lcString, ",", CHR(13)))
Just to expand this answer a little bit. Suppose, you have a text file like this:
"Nick",12,0,"Nekloudov"
"Yuri",50,333,"Rubinov"
Number of records*number of fileds should be less than 65000 (max number, which array can handle).
You can do:
lcStr=filetostr("yourFile.txt")
, then proceed with Sergey's code.
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