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 -~----------~----~----~----~------~----~------~--~---
