The only way I can see this working is for the array to be reorganised. If it contained "D07]D14]D21]M01]M03]M06]Y01" then you could use an 'AL' LOCATE to find the correct position for "D18" (not just "18") - or "M02", "M04", or whatever. Otherwise it seems it would have to be a loop with comparisons against each value because months and years can't be evaluated to a fixed number of days. If you're looking for a number of weeks you'd have to look for it in terms of days.
On May 3, 5:42 pm, "Bruce Willmore" <[email protected]> wrote: > That's an interesting proposition. I believe (haven't tested it) that if you > can modify your elements with single digits (ie 7D) to two digits (07D), then > you should be able to use: > > LOCATE '18D' IN ARRAY<1> BY 'AR' SETTING POS ELSE NULL > > However, I'm not sure that I like this code. The only reason that it would > work (assuming that it does) is because your representation for Day, Month, > and Year happen to be in ascending order. If that ever changes, for whatever > reason, (suppose you need to do Weeks), then this goes out the window. I > think you'd be better off converting your different values so that they all > have a common base (days) and then evaluate. > > ----- Original Message ----- > From: M Rizwan > To: [email protected] > Sent: Sunday, May 03, 2009 9:20 AM > Subject: T24 : LOCATE command > > 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 -~----------~----~----~----~------~----~------~--~---
