question: private String replaceInlist ( String str ) { try { Pattern pt = Pattern . compile ( "(?i)\\s*IN\\s*\\('?\\d+'?," ) ; Matcher m = pt . matcher ( str ) ; if ( m . find ( ) ) { int start = m . start ( ) ; int idx = str . indexOf ( ')' , start ) ; if ( idx < 0 || idx == str . length ( ) - 1 ) return str . substring ( 0 , start ) + " IN (......)" ; else return str . substring ( 0 , start ) + " IN (...) " + str . substring ( idx + 1 ) ; } } catch ( Exception ex ) { } return str ; }
target:  We might have a case processlist cannot print the full inlist This should be used after all other normalize operations