>I have a very long comma delimited string. I want to pull that data into a table. I was wondering what the easiest way to do it may be.
>
>The string looks something like this "a,b,a,b,a,b,a,b" etc.....
>where a is a measuerment like ".45032" and b is a gage number like "01"
>
>I was thinking of Doing a strtofile() then an append from file delimited. but that seems a little cumbersome. Does anyone know of a better way?
This works with VFP6, VFP7 and above have additional parameters on ALINES you can use.
cInfoList = ".45032,01,.12345,02"
ALINES(aInfo,STRTRAN(cInfoList,",",CHR(13)+CHR(10)))
DIMENSION aInfo[ALEN(aInfo,1)/2,2]
Whoops, forgot the part about the table.
APPEND FROM ARRAY aInfo