I have a table that contains the titulo
field. I have a query and I want to sort alphabetically by it, however, some fields are with HTML codes, I'll give examples:
Goat slaughtering and meat processing
Slaughter and Commercialize% of Animals
In the second example, for the user the correct name çã
appears, but the bank is in the form shown above.
Is it possible to sort alphabetically by considering text without html codes as "readable" text?