Sort Array by Column X

Subject: Sort Array by Column X
From: Richard Lake <email@hidden>
Date: Wed, 21 Jul 2010 10:26:21 +0100

Hi all,

I have a CSV like the extract below that I have read into Applescript in as an array:

"Customer GUID","Form GUID","Contact GUID","Form Type","Ref No","Account Number","Company Name","Contact Name","Contact Address","Email address","Artwork awaiting Response","Days no Response","Special Pricing","Despatch Date"

^^^ Column headings, not stored in array

"2C7B2550-7C3B-43F4-B3A7-7BC271A56FA4","031AA79C-80BA-4159-9B21-139548CB0BEE","7F99B8A9-54BB-44E1-BEC8-C0D15984E475","QT","2542","M0080P","SENSOREDCOMPANYNAME","SENSORED_CONTACTNAME","SENSORED_CONTACTADDRESS","SENSORED_EMAILADDRESS","No","1","No",""

"A9C7CE4D-8DE0-416F-9AFD-1AFA6273CBF1","F379BA62-18A2-43D9-A232-A29E88FA764C","7FE82869-F9DF-4CB0-A1A7-6CF33CFE29FD","QT","2543","R0075P","SENSOREDCOMPANYNAME","SENSORED_CONTACTNAME","SENSORED_CONTACTADDRESS","SENSORED_EMAILADDRESS","No","1","No",""

Different extract showing how the array is stored in Applescript:

{{"1C0096C0-613C-42E4-BF8D-768ADB7DAE5C", "E908B072-F1F2-4A08-93E8-6F9F36E74721", "E81FC87C-C79B-4BE2-88BC-79BB9F3B6819", "SO", "2891", "R0014C", "SENSOREDCOMPANYNAME", "SENSORED_CONTACTNAME", "SENSORED_CONTACTADDRESS", "SENSORED_EMAILADDRESS", "No", "7", "No", "14/06/2010 - Fully Despatched"}, {"5C06971B-90BD-47C6-94A1-B0DA8BCFAD5B", "8DC5A202-EE84-4E78-97C2-F0D39B2FEB99", "C7FA819A-1E09-40FB-B274-A10DBF3A6745", "SO", "2892", "B0091C", "SENSOREDCOMPANYNAME", "SENSORED_CONTACTNAME", "SENSORED_CONTACTADDRESS", "SENSORED_EMAILADDRESS", "No", "7", "No", ""}}

---

I need a quick sort routine that will simply sort this array by a specified column. Eg: my sortArraybycolumn(theList,5)

Any help much appreciated.

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

Follow-Ups:
- Re: Sort Array by Column X
  - From: "Mark J. Reed" <email@hidden>
- Re: Sort Array by Column X
  - From: Steve Thompson <email@hidden>
- Re: Sort Array by Column X
  - From: Emmanuel LEVY <email@hidden>

Prev by Date: Re: Rant Generator
Next by Date: Re: Sort Array by Column X
Previous by thread: Re: AppleScript-Users Digest, Vol 7, Issue 370
Next by thread: Re: Sort Array by Column X
Index(es):
- Date
- Thread