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

Question

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?

Gianni Ceresa · Answer

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.