> > Hmmm... If you need it, somewhere I have a "collapseWhitespace" > > implementation that we use... It's equivalent to trim plus replaces n > > occurrences of Char.isWhitespace(x) with a single space char... > > > Great! I guess that's exactly what we need. > Ehm, just one thought: Is it ok to collapse all whitespaces of the > sql query? Or should we only collapse whitespaces outside of " or ', > so for example a statement like text = "ggg hhh yyy", should > not be collapsed to text = "ggg hhh yyy". This is really more > complicated than it should. > Luca just suggested to simply use a String query = StringUtils.replace(sb.toString(), "\r", " ", -1);
which could solve the problems as well. Hmm Carsten
