tag:blogger.com,1999:blog-161837998407337725.post5725623763669345179..comments2023-07-10T18:18:55.558+10:00Comments on Everythin' Essbase: Reverse Mapping using Hierarchy-Driven SmartlistsPHChanhttp://www.blogger.com/profile/13872156326947217576noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-161837998407337725.post-77053568258214641832017-08-05T20:20:56.239+10:002017-08-05T20:20:56.239+10:00Thanks for the feedback, Pete. Yeah, it's a g...Thanks for the feedback, Pete. Yeah, it's a good idea to use a regular expression to get the numeric values.PHChanhttps://www.blogger.com/profile/13872156326947217576noreply@blogger.comtag:blogger.com,1999:blog-161837998407337725.post-3091535887978320532017-08-05T18:51:51.514+10:002017-08-05T18:51:51.514+10:00Hey PH,
Great first post!
I've been thinki...Hey PH, <br /><br />Great first post! <br /><br />I've been thinking about it - see my post shortly - but I think a nice change would be to change the substring with a regular expression match to pickup the numeric values. <br /><br />I'm not sure if there is a hardcoded piece of logic that means it'll always be 7 characters - but this will return all of the numbers in the string no matter how many there are. <br /><br />@CalcMgrDoubleFromString(@CalcMgrFindFirst(@ALIAS(@NAME(@CURRMBR(COA),"SLAliases"),"[0-9]+", @_true));<br /><br />Cheers<br />Pete<br />Petehttps://www.blogger.com/profile/06439105832806165572noreply@blogger.com