RE: Witango-Talk: parsing results

[Ben Johansen]

This could be interesting   Rbase has a function called SRPL, you can use this with a CUSTOM COLUMN with the search action.   Try this (SRPL(COLUMN,’-‘,’,’,0)   I am wondering if the comma separation would be picked up by witango as separate array elements   defines: CUSTOM COLUM = Right Click in columns area of the Search action and select custom column)   Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm  Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Atrix Wolfe Sent: Tuesday, August 27, 2002 11:32 AM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: parsing results   im using R:Base actualy.  I dont know anything about stored procedures, but i heard it was possible that i could make something in C that could be used in R:Base.  If i could get either one to do this with reasonable speed id be a happy man :P   ----- Original Message ----- From: Ben Johansen To: Multiple recipients of list witango-talk Sent: Tuesday, August 27, 2002 11:18 AM Subject: RE: Witango-Talk: parsing results   In reading further down in you email it occurred to me that you might want to look into Stored procedure in the database or Server Side JavaScript   I know there are those on the list that don’t like Stored Procedures, but there are certain things that Witango is not the best answer for.   What database are you using? You might be able to do it in custom columns in the search action with built in database functions   Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm  Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Atrix Wolfe Sent: Tuesday, August 27, 2002 11:00 AM To: Multiple recipients of list witango-talk Subject: Witango-Talk: parsing results   hello, as the result of a query, i get an array of text where each element looks something like "0000-00000-000-0000".  What i would really like to do is grab all of these values and "break them apart" at the dashes and create 4 different lists.  Does anyone know a good way to do this?  Right now all i can think of is do an <@rows> with a whole lot of assigns which would take way too long for a possibility of 7000 or more results to break apart.   Thanx, Atrix