Application: gvSIG desktop

		// Converts all apostrophes between aphostrophes to double inverted commas ( " )

		int index = 0;

		boolean is_word = false; // by default isn't a word

		String formatted_query = new String();

		char c;

		while (index < query.length()) {

			c = query.charAt(index);

			if (c == '\'') {

				if (is_word == false) {

					if ((index > 0) && ((query.charAt(index-1) == ' ') || (query.charAt(index-1) == '(')) ) {

						is_word = true;

					}

					formatted_query += c;

				}

				else {

					if (index == (query.length() -1)) {

//						is_word = false;

						formatted_query += c;

					}

					else {

						if (((query.charAt(index+1) == ' ') || (query.charAt(index+1) == ')')) ) {

							is_word = false;

							formatted_query += c;

						}

						else {

							formatted_query += "\""; // Convert ' to "

						}

					}

				}

			}

			else {

				formatted_query += c;

			}

			index ++;

		}		

		// Converts all ocurrences of the symbol " ( double inverted commas ) to space because Zql doesn't support that symbol

			completeQuery = preQuery + formatted_query.trim().replaceAll("\"", " ");

			completeQuery = formatted_query.trim().replaceAll("\"", " ");