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;
}

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 ; }
we might have a case processlist cannot print the full inlist this should be used after all other normalize operations
