What's the function that does this? I have an attribute in the form of DISTRIBUTOR - SALES REP. I need to find the location of the " - " so I can use SUBST to break out the Distributor and Rep. I just can't remember the function.
Thanks
TI function to find location of a string within a string?
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TI function to find location of a string within a string
Scan.ChrisF79 wrote:What's the function that does this? I have an attribute in the form of DISTRIBUTOR - SALES REP. I need to find the location of the " - " so I can use SUBST to break out the Distributor and Rep. I just can't remember the function.
Thanks
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.