Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 7 of 7 total

Tue, Jul 28 2009 10:52 PM	Permanent Link
Steve Gill	Is there an opposite to the LIST function? Say I have a concatenated list of values created by the LIST function, eg. 'John\|Jane\|Paul'. Is there a function that will separate this into individual values? Regards, Steve
Wed, Jul 29 2009 1:22 AM	Permanent Link
Richard Harding	Steve, >>Is there an opposite to the LIST function? Say I have a concatenated list of values created by the LIST function, eg. 'John\|Jane\|Paul'. Is there a function that will separate this into individual values? If you have Delphi 2007 you can use TStringLists to parse list values. Use TStringList LineBreak property. Other useful properties are StrictDelimiter, Delimiter, DelimitedText. Richard Harding
Wed, Jul 29 2009 2:56 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Steve If all you want is to access outside the query then Richard's suggestion is about the best. If not what are you trying to achieve? Roy Lambert [Team Elevate]
Wed, Jul 29 2009 12:21 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Steve, << Is there an opposite to the LIST function? Say I have a concatenated list of values created by the LIST function, eg. 'John\|Jane\|Paul'. Is there a function that will separate this into individual values? >> Do you mean "rows" when you say "individual values" ? As in convert the list into a table whoses rows consist of one column that is the string value ? -- Tim Young Elevate Software www.elevatesoft.com
Wed, Jul 29 2009 6:37 PM	Permanent Link
Steve Gill	"Tim Young [Elevate Software]" wrote: > Do you mean "rows" when you say "individual values" ? As in convert the > list into a table whoses rows consist of one column that is the string value? Sorry, I should have explained it better. Yes, that's exactly what I meant. Regards, Steve
Thu, Jul 30 2009 1:15 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Steve, << Sorry, I should have explained it better. Yes, that's exactly what I meant. >> You could write a function to do so, but unfortunately we don't allow functions to return tables or result sets that can be used in a FROM clause, etc. -- Tim Young Elevate Software www.elevatesoft.com
Thu, Jul 30 2009 5:57 PM	Permanent Link
Steve Gill	"Tim Young [Elevate Software]" wrote: > You could write a function to do so, but unfortunately we don't allow > functions to return tables or result sets that can be used in a FROM clause, > etc. Ok, thanks Tim. No problem, I can do it in Delphi code. Just wanted to see if it was possible to do it in SQL Steve