Not even sure if regex is the only way. Just need a way to find it.
Have found something for java, which might be useful in a way?
Code: Select all
public static String addTildeOptions(String searchText) {
return searchText.toLowerCase()
.replaceAll("[aáàäâã]", "\\[aáàäâã\\]")
.replaceAll("[eéèëê]", "\\[eéèëê\\]")
.replaceAll("[iíìî]", "\\[iíìî\\]")
.replaceAll("[oóòöôõ]", "\\[oóòöôõ\\]")
.replaceAll("[uúùüû]", "\\[uúùüû\\]")
.replace("*", "[*]")
.replace("?", "[?]");
}
Code: Select all
SELECT * from table WHERE lower(column) GLOB "*addTildeOptions(searchText)*"
But for hebrew I will need other letters for it, that what it makes more difficult, and at the moment I'm not even sure if the sentence markers are not part of the character, as they are not possible to delete seperately in libre office writer.
But could something similar help.
And anyway you regexp explenation was a bit to complicated for me.