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
Tagged:
0