Re: Sorting a string alphabetically.
Good, I just couldn't remember if it went back that far. I had the old 4.5 docs and it was in there. Dave - Original Message - From: "Darren Adams" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 9:09 AM Subject: RE: Sorting a string alphabetically. Works on Server 4 -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 December 2001 14:03 To: CF-Talk Subject: Re: Sorting a string alphabetically. Ah - too fast on the previous post: ListSort(list, "TextNoCase", "ASC", ",") Dave - Original Message - From: "Darren Adams" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 8:46 AM Subject: Sorting a string alphabetically. Hello All, Just looking for a function to take a string of comma delimited words and sort them in alphabetical order. e.g. "Company structure,Executive team,Jobs,Locations,Prod_Introduction" Can anyone advise ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] "Data + Structure = INFORMATION" ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorting a string alphabetically.
Try ListSort() Extract of help text ListSort Sorts and delimits the items in a list according to the specified sort type and sort order. Note ColdFusion ignores empty list elements; thus, a list that is defined as "a,b,c,,,d" is treated as a four element list not as a six element list. Syntax ListSort(list, sort_type [, sort_order] [, delimiter ]) list List to be sorted. The items in the list must be separated by commas or otherwise delimited. sort_type The type of sort to be executed. You can specify any of the following sort types: Numeric - sorts numbers. Text - sorts text alphabetically. Textnocase - sorts text alphabetically. The case is ignored. sort_order The order to be followed. You can specify any of the following: Asc - (Default) Ascending sort order. Desc - Descending sort order. delimiter Specify the character(s) used to delimit elements in the list. Default is comma ( , ). Example ListSort Example ListSort Example SELECT Username, Subject, Posted FROM Messages Here is the unsorted list. #myList# Here is the list sorted alphabetically: #sortedList# Here is a numeric list that is to be sorted in descending order. #sortedNums# Here is a list that must be sorted numerically, since it contains both negative and positive numbers, as well as decimal numbers. #sortedNums2# Here is a list that is to be sorted alphabetically without consideration of case. #sortedMix# -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: 06 December 2001 13:46 To: CF-Talk Subject: Sorting a string alphabetically. Hello All, Just looking for a function to take a string of comma delimited words and sort them in alphabetical order. e.g. "Company structure,Executive team,Jobs,Locations,Prod_Introduction" Can anyone advise ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] "Data + Structure = INFORMATION" ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorting a string alphabetically.
Works on Server 4 -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 December 2001 14:03 To: CF-Talk Subject: Re: Sorting a string alphabetically. Ah - too fast on the previous post: ListSort(list, "TextNoCase", "ASC", ",") Dave - Original Message - From: "Darren Adams" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 8:46 AM Subject: Sorting a string alphabetically. Hello All, Just looking for a function to take a string of comma delimited words and sort them in alphabetical order. e.g. "Company structure,Executive team,Jobs,Locations,Prod_Introduction" Can anyone advise ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] "Data + Structure = INFORMATION" ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sorting a string alphabetically.
Ah - too fast on the previous post: ListSort(list, "TextNoCase", "ASC", ",") Dave - Original Message - From: "Darren Adams" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 8:46 AM Subject: Sorting a string alphabetically. Hello All, Just looking for a function to take a string of comma delimited words and sort them in alphabetical order. e.g. "Company structure,Executive team,Jobs,Locations,Prod_Introduction" Can anyone advise ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] "Data + Structure = INFORMATION" ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sorting a string alphabetically.
CF 4.5 and up: ListSort(list, ",") Dave - Original Message - From: "Darren Adams" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 8:46 AM Subject: Sorting a string alphabetically. Hello All, Just looking for a function to take a string of comma delimited words and sort them in alphabetical order. e.g. "Company structure,Executive team,Jobs,Locations,Prod_Introduction" Can anyone advise ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] "Data + Structure = INFORMATION" ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorting a string alphabetically.
That was going to be my next approach. Thanks -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: 06 December 2001 13:56 To: CF-Talk Subject: RE: Sorting a string alphabetically. You could covert it to a structure and then sort it. Example convert it to an array then use ArraySort Then if you still need the list, convert it back to a list format. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 8:46 AM To: CF-Talk Subject: Sorting a string alphabetically. Hello All, Just looking for a function to take a string of comma delimited words and sort them in alphabetical order. e.g. "Company structure,Executive team,Jobs,Locations,Prod_Introduction" Can anyone advise ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] "Data + Structure = INFORMATION" ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorting a string alphabetically.
Thanking you kindly ! *tips hat* -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 06 December 2001 13:55 To: CF-Talk Subject: RE: Sorting a string alphabetically. ListSort() EC -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 8:46 AM To: CF-Talk Subject: Sorting a string alphabetically. Hello All, Just looking for a function to take a string of comma delimited words and sort them in alphabetical order. e.g. "Company structure,Executive team,Jobs,Locations,Prod_Introduction" Can anyone advise ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] "Data + Structure = INFORMATION" ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorting a string alphabetically.
ListToArray Arraysort Arraytolist This may work. HTH -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 8:46 AM To: CF-Talk Subject: Sorting a string alphabetically. Hello All, Just looking for a function to take a string of comma delimited words and sort them in alphabetical order. e.g. "Company structure,Executive team,Jobs,Locations,Prod_Introduction" Can anyone advise ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] "Data + Structure = INFORMATION" ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorting a string alphabetically.
You could covert it to a structure and then sort it. Example convert it to an array then use ArraySort Then if you still need the list, convert it back to a list format. -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 8:46 AM To: CF-Talk Subject: Sorting a string alphabetically. Hello All, Just looking for a function to take a string of comma delimited words and sort them in alphabetical order. e.g. "Company structure,Executive team,Jobs,Locations,Prod_Introduction" Can anyone advise ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] "Data + Structure = INFORMATION" ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Sorting a string alphabetically.
ListSort() EC -Original Message- From: Darren Adams [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 8:46 AM To: CF-Talk Subject: Sorting a string alphabetically. Hello All, Just looking for a function to take a string of comma delimited words and sort them in alphabetical order. e.g. "Company structure,Executive team,Jobs,Locations,Prod_Introduction" Can anyone advise ? Cheers, Darren Adams Web Developer Marketing Department Systems Union Email: [EMAIL PROTECTED] "Data + Structure = INFORMATION" ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists