two soluces
(1) paste in a Word processor document, export it as text file with the extension name ".csv"
If the used separator is matching Numbers requirements you will be able to import it in Numbers.
The requirements are simple:
if your system uses period as decimal separator, your CSV file must use comma to separate values.
if your system uses comma as decimal separator, your CSV file must use semicolon to separate values.
(2) you may use this script
--[SCRIPT]
if character 2 of (0.5 as text) is "." then
set delim to ","
else
set delim to ";"
end if
-- set delim to "@" -- If your source doesn't match Numbers requirements, activate this instruction and edit the value to fit your needs.
set the clipboard to my remplace(the clipboard as text, delim, tab)
on remplace(t, d1, d2)
local l
set AppleScript's text item delimiters to d1
set l to text items of t
set AppleScript's text item delimiters to d2
set t to l as text
set AppleScript's text item delimiters to ""
return t
end remplace
--[/SCRIPT]
Copy your CSV datas
run the script
paste where you want.
Yvan KOENIG (from FRANCE mardi 3 février 2009 17:07:59)