Re: Sort Array by Column X
Re: Sort Array by Column X
- Subject: Re: Sort Array by Column X
- From: Richard Lake <email@hidden>
- Date: Wed, 21 Jul 2010 13:46:46 +0100
Didn't try this as your delimiter is simply a comma whereas my fields having quote marks surrounding them.
set column_id to 5 set posix_path_to_csv to POSIX path of ((path to scripts folder) & "formdb.csv" as string) set delimiter to quoted form of (quote & "," & quote)
set sorted_file to do shell script ("sort -n -t " & delimiter & " -k " & column_id & " " & posix_path_to_csv)
Trying alternative delimiter strings, but keep facing the same error:
error "sort: multi-character tab `\",\"'" number 2
On 21 Jul 2010, at 12:35, Steve Thompson wrote: set column_id to 2 set posix_path_to_csv to "/Users/steve/testfile.csv" set sorted_file to do shell script ("sort -n -t , -k " & column_id & " " & posix_path_to_csv)
Richard Lake Marketing Manager Tel: 0800 158 3898 | Email: email@hidden
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden