Hi,
Here is a script to start, test it in the AppleScript editor
-------------------------------------------------------------------------
setthisCSVFiletochoose file
if (thisCSVFile as string) ends with ".csv" then -- CSV only
setnumbersFiletotext 1 thru -5 of (thisCSVFileasstring)
tell application "Numbers"
open thisCSVFile
tell front document
tell table 1 of sheet 1
add column after column "A"
set value of cell 1 of column "B" to "name"
tell row 2 to set value of cell 2 to my convertListToText(get value of cells 3 thru 5) --C2, D2 and E2
repeat with i from 3 to (count row) --concatenate the values of each row
tell row i to set value of cell 2 to my convertListToText(get value of cells 3 thru -1) -- cell "C" trought the end of this row
end repeat
end tell
save as "LSDocumentTypeNativeDocument" in numbersFile -- save as ".numbers"
close saving no
end tell
end tell
endif
onconvertListToText(tList)
settidtotext item delimiters
settext item delimitersto " " -- separator = space
settValtotListastext -- convert AppleScript's list to string --> (value separated by space)
settext item delimiterstotid
return tVal
endconvertListToText
-------------------------------------------------------------------------
if it works as you want;
Here is the script for a folder action.
-------------------------------------------------------------------------
onadding folder items tothis_folderafter receivingadded_items
repeatwiththisCSVFileinadded_items
if (thisCSVFile as string) ends with ".csv" then -- CSV only
set numbersFile to text 1 thru -5 of (thisCSVFile as string)
tell application "Numbers"
open thisCSVFile
tell front document
tell table 1 of sheet 1
add column after column "A"
set value of cell 1 of column "B" to "name"
tell row 2 to set value of cell 2 to my convertListToText(get value of cells 3 thru 5) --C2, D2 and E2
repeat with i from 3 to (count row) --concatenate the values of each row
tell row i to set value of cell 2 to my convertListToText(get value of cells 3 thru -1) -- cell "C" trought the end of this row
end repeat
end tell
save as "LSDocumentTypeNativeDocument" in numbersFile -- save as ".numbers"
close saving no
end tell
end tell
end if
endrepeat
endadding folder items to
onconvertListToText(tList)
settidtotext item delimiters
settext item delimitersto " " -- separator = space
settValtotListastext -- convert AppleScript's list to string --> (value separated by space)
settext item delimiterstotid
return tVal
endconvertListToText
-------------------------------------------------------------------------
In Mac help --> AppleScript Help, type folder actions to learn how to enable "folder actions", how to assign a script to a folder, and where to save the script.
