Metacat

  /**

   * Normalizes text prior to insertion into the HARVEST_LOG or

   * HARVEST_DETAIL_LOG tables. In particular, replaces the single quote

   * character with the double quote character. This prevents SQL errors

   * involving words that contain single quotes. Also removes \n and \r

   * characters from the text.

   * 

   * @param text  the original string

   * @return      a string containing the normalized text

   */

  String dequoteText(String text) {

    char c;

    StringBuffer stringBuffer = new StringBuffer();

    for (int i = 0; i < text.length(); i++) {

      c = text.charAt(i);

      switch (c) {

        case '\'':

          stringBuffer.append('\"');

          break;

        case '\r':

        case '\n':

          break;

        default:

          stringBuffer.append(c);

          break;

      }

    }

    return stringBuffer.toString();

  }