Another question about puting data in tables

If I have data that looks like this

Some Data|More Data|Yet Some More Data|That’s All the Data

what is the best way to format it so that I can put it in a table. It comes out of my sqlite database like this. Each set of data has it’s own column in the table.

Usually data comes out of sqlite3 like that, which is one row of a table. You can get the multiple rows in a list like this:


--this give you a list of where every item is a row
set N to paragraphs of theEntries
set tNames to {}
--save original AppleScript's text item delimiters for later
set tid to AppleScript's text item delimiters
--change them to a pipe
set AppleScript's text item delimiters to "|"
--repeat with P in every row of the entries
repeat with P in N
	--this line divides th row in the columns
	set end of tNames to text items of P
end repeat
--always set the delimiters back
set AppleScript's text item delimiters to tid

gecko

:smiley: That works perfectly. Now I’ve just got to work on editing and deleting data. Thanks for your help.