I am trying to use regexp like to identify numeric pattern XXX XX XXXX within a string i.e numbers in pattern 3 2 4.
Regexp_like(column1, ‘/d{3}/s/d{2}/s/d{4}’)
Where column1 is a varchar or clob column potentially containing the numeric pattern.
But records were the last set of digits is more then 4 are also being pulled up. Is there a way to limit the exact number of digits to check for using regexp_like. Appreciate any suggestions or help.
Even if a number is in pattern 3 2 5 or more then 5 in the last set ..they are being pulled up by my regexp like. I need the exact pattern of 3 2 4 matched in the varchar2 or clob column between aphanumetic and other punctuation marks within the column.
For example data in the column may be something like- ‘This is a pattern test for XXX XX XXXX. So 115 34 45678
should not pull up because last part is 5 digits’.
Please share ideas and or suggestions.