Hi
I need to clean up phone-numbers. Somehow I got a Excel list that has
weird graphical characters trailing some of the entries.
My DB is UTF8 so it would store this mess but I don't like to import it
in the first place.
OK, I know how to read the stuff into a temporary table to clean it up
before the actual import.
How can I do an update on the column that deletes every char that is not
in a given set of chars like '+- 0123456/()'?
Second but similar question:
How can I select records that have fields that contain characters not
included in a given alphabet?
E.G. find fields that contain some char not in 0-9,a-z,A-Z, +-()/?
regards
Andreas