Forum Stats

  • 3,855,150 Users
  • 2,264,464 Discussions


Returning a substring in Discoverer

Jim Farris at Nuance
Jim Farris at Nuance Member Posts: 2
edited Feb 17, 2016 11:58AM in Discoverer

Hi Folks,

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.

Any thoughts?


This discussion has been closed.