Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to take integers from a column which are in different positions in each raw in OAC?

Received Response
11
Views
1
Comments
User_AYOKV
User_AYOKV Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Eg : first raw value is 'abcdefgh, (2291)' and 2nd raw is 'abcde, (8124) abcdefg' and 3rd raw is 'abc, (1030) 2lmnop'. I need to take the first 2 integer after bracket. Substring is not working bcoz each raw integer is in different position. Is there any other way in OAC?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    You are almost there with the usage of SUBSTRING , all you need now is to use LOCATE to find the position of the bracket, and use that for your substring.

    Use LOCATE as the beginning of the substring, with a +1 to not get the bracket but just the numbers after.