Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comma Delimited File
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00484983
Message ID:
00485153
Views:
9
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform