LiveCode Forums.

Code: Select all

on ReadDataFile
    answer file "Select a file"
   
   put URL ("file:" & it ) into tFileContents
   
   Put tFileContents into field "text" on Card "Database" 
   
   put line 1 of tFileContents into tColumnTitles    ## Creates Columns from the contents of the CSV's first line 
   replace comma with return in tColumnTitles
   set the dgProp["columns"] of group "AppData" on Card "Database" to tColumnTitles
   
   delete line 1 of tFileContents
   replace "," with tab in tFileContents
   Put tFileContents into field "text" on Card "Database" 
   set the dgText of group "AppData" on Card "Database" to tFileContents
end ReadDataFile