You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Dynamic Substring Function - Essbase Equivalent of FIND/SEARCH Function from Excel

Summary:

We have a need to perform dynamic member name lookups with member names that are varying lengths (something outside of our control as they come from a source system). We essentially need to be able to do a SUBSTRING but without a hardcoded start and/or end parameter. In Excel, this can easily be accomplished by nesting a SEARCH/FIND function inside of a LEFT, RIGHT, or MID function. For example, I want to return the position of the underscore in a member name, such as returning 8 from "Member1_ABC" or returning 10 from "Member123_ABC". This value of 8 or 10 would

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!