LiveCode Forums.

Code: Select all

on mouseUp
   local tFileName, tFileContents

answer file "Please choose a file to import" with type "Comma Separated Values|csv|CSV"
if the result is not "cancel" then
put it into tFileName

## Get the contents of the file
put URL ("file:" & tFileName) into tFileContents

## Display the file contents in the field
put line 1 of tFileContents into tColumnTitles
replace comma with return in tColumnTitles
//set the dgProp[ "columns" ] of group "MobileNumbersDataGrid" to tColumnTitles

end if

replace comma with tab in tFileContents
set the dgText[true] of group "MobileNumbersDataGrid" to tFileContents


## Get the complete data
put the DGData of grp "MobileNumbersDataGrid" into tArray

## Set the data of the datagrid back to the now modified array
set the DGData of grp "MobileNumbersDataGrid" to tArray


end mouseUp

Code: Select all

...
## tFileContent = the content of your CSV file
## I leave out that part!

## WAHTEVER = the name of the 1 column you want to fill/modify/overwrite
put the dgData of grp "MobileNumbersDataGrid" into tDGData
put 1 into tCounter
repeat for each key tKey in tDGData
  put line tCounter of tFileContent into tDGData[tKey]["WHATEVER"]
  ## or ITEM 1 of line tCounter... ?
  add 1 to tCounter
end repeat
set the dgData of grp "MobileNumbersDataGrid" to tDGData
...