you can create a table field that points to something the data can reference, then turn that comma separated list into an external qual, then walk that table to create the records.
For example, if your field contains companies, you may have a value like this: BMC,HP,Sun If you have a company table, point a table field at it, then convert that list to an external qual using the replace function: 'Company' = "BMC" OR 'Company' = "HP" OR 'Company' = "Sun" Then you can walk the table with a filter or active link guide. Axton Grams On 3/5/07, Christopher Gillman <[EMAIL PROTECTED]> wrote:
** Listers, I'm playing around with some data, and have checked the KB, and have asked several people about this but can't seem to find the correct answer. I know that it's possible to do in Remedy, but it's been so long since I've fooled around with it, I can't remember how to do it. What I'm trying to do is take a record that has multiple fields which contain multiple strings of data, delimited by a comma ",". For example: Hi1, Hi2, Hi3, Hi4, etc. Is there a function or process that can be used to parse these into their own records? I.e. Record1 = Hi1 Record2 = Hi2 Record3=Hi3 etc. Or, as a second option, is there a way to create a table, which lists these as separate records without manipulating the data? As always, help is appreciated! Chris __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"