If its a 2D array, there's a udf at CFLib.org that can handle this. From the site: -- Takes an array, sortcolumn value, sort type (numeric, text, textnocase), and optional sort order (defaults to asc) as arguments. Returns an array sorted by the sortcolumn in the second dimension according to the type and order. -- You can download it at http://www.cflib.org/udf.cfm?ID=390
hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- > >-----Original Message----- >From: Michel Deloux [mailto:[EMAIL PROTECTED] >Sent: Thursday, January 19, 2006 12:14 PM >To: CF-Talk >Subject: Sorting array > >Hi all > >I have an array with elements like this: > > >1 02/03/2006||3||Seattle||20||ATT||o||Overwrite||390||20060203 >2 02/07/2006||3||Seattle||20||ATT||a||Append||390||20060207 >3 01/26/2006||6||Phoenix||20||ATT||o||Overwrite||390||20060126 > >I need to sort this elements in date format using the final >variable(yyyymmdd). The final result: > >1 01/26/2006||6||Phoenix||20||ATT||o||Overwrite||390||20060126 >2 02/03/2006||3||Seattle||20||ATT||o||Overwrite||390||20060203 >3 02/07/2006||3||Seattle||20||ATT||a||Append||390||20060207 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230023 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54