Substitute function

Suggest and discuss enhancements for TM1
Post Reply
jstrygner
MVP
Posts: 195
Joined: Wed Jul 22, 2009 10:35 pm
OLAP Product: TM1
Version: 9.5.2 FP3
Excel Version: 2010

Substitute function

Post by jstrygner »

Function that works like MSExcel's SUBSTITUTE in Rules and TI.
You have an acceptable workaround in TI, but it gets so much harder to live without it when it comes to Rules as described in this thread:
http://forums.olapforums.com/viewtopic.php?f=3&t=2860
Possible syntax (based on MSExcel): SUBSTITUTE(text, old_text, new_text)
Post Reply