You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    SUBSTRING function to separate multiple Valid Grades

    edited Aug 1, 2018 7:46PM in Reporting and Analytics for HCM 4 comments

    Summary

    We are trying to separate each valid grade into a separate column

    Content

    When pulling job codes and valid grades, all valid grades are in one cell. We would like to separate them into multiple columns (or duplicate rows ideally, but that has been more difficult and we can work with multiple columns). I was able to get the first grade and the second grade using the below formulas, but cannot figure out the formula to get the third or fourth grade. 

    Grade 1: CASE WHEN LOCATE(',', "Job"."Valid Grades")=0 THEN NULL ELSE SUBSTRING("Job"."Valid Grades" FROM 1 FOR LOCATE(',', "Job"."Valid Grades")-1) END

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!