If "18" is the entire given value then what is it that determines that "18" follows "14D", and not "6M" or "1Y" ? If the given value was "18D" then you could perhaps use a 'natural sorting' algorithm to find the position. A binary search, using this 'natural sort' method, would need at most lg N + 1 comparisons, where N is the number of multi-values in the list.
How large can the list of multi-values get? Dan On Sun, May 3, 2009 at 9:20 AM, M Rizwan <[email protected]> wrote: > How can we use LOCATE command to find out the position of an integer(days > to maturity) against mutli value set of alphanumerics (maturity band).Given > that the multvalue set is presorted. > > For example: > > I want to locate position of "18" which is "3" in the following multivalues > "7D]14D]21D]1M]3M]6M]1Y". > > This is a related to Money Market maturity band values, Is there any T24 > function already available or do we need to develop it? > > > Thanks > > MR > --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
