Re: Sort Array by Column X
Re: Sort Array by Column X
- Subject: Re: Sort Array by Column X
- From: Tommy Bollman <email@hidden>
- Date: Wed, 21 Jul 2010 21:59:33 +0200
Hello.
There is no such thing as a favorite spread sheet program. You just choose the one that itches you less than the other. :)
(Microsoft has crippled Excel2008 for Mac)
On 21 Jul 2010, at 15:20, Mark J. Reed wrote:
> Unless you have commas in your quoted strings, just using comma as the
> delimiter works fine. If you do have commas in your quoted strings,
> you need full-on CSV parsing of the sort provided by a full-on CSV
> parser. Might I suggest scripting your favorite spreadsheet program
> to load the file and sort the resulting cells by the desired column?
>
>
>
> On Wed, Jul 21, 2010 at 8:46 AM, Richard Lake
> <email@hidden> wrote:
>> 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)
>>
>> Thanks
>>
>> 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
>>
>
>
>
> --
> Mark J. Reed <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
>
Best regards
Tommy Bollman
--------------------------------------------------------------------------------------------------
Mollison's Bureaucracy Hypothesis:
If an idea can survive a bureaucratic review
and be implemented it wasn't worth doing.
_______________________________________________
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