LiveCode Forums.

Code: Select all

// Assume that myData contains all data.
// For the occasion, assume that gDataArray is a global variable.
// line 1 contains column titles
// first line of each line is a label
set the itemDel to tab
put line 1 of myData into myTitles
// item 1 should be empty or irrelevant
delete item 1 of myTitles
delete line 1 of myData
put 1 into myItemCounter
repeat for each item in myTitles
  add 1 to myItemCounter
  put 0 into myLineCounter
  repeat for each line in myData
    add 1 to myLineCounter
    put item myItemCounter of line myLineCounter into gDataArray[item myItemCounter of myTitles][item 1 of line myLineCounter of myData]
  end repeat
end repeat