- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 68 Insurance
- 536.9K On-Premises Infrastructure
- 138.5K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Returning a substring in Discoverer
I have done some searching and have not found my answer so I figured I'd post a question. Likely it has been asked and answered, sorry about any repeat question.
I am looking to use a string or substring function in Discoverer. I have some decode and case functions working fine. In this example I want to pull the first one or two characters from a column Grade. Grade has the form of XX.## or X.##.
Normally I would look for the length of the string prior to the "." and then return the string of that length.