Hi SQLiters,
I am trying to clean up some text in a database that has some weird
non-printable unicode characters.
For instance:
.mode insert
select distinct "Name", length ("Name"), substr("Name",-1,1) from "My Table"
gives:
INSERT INTO table VALUES('Roundup Ready®',15,'')
As you can see, the printable text is only 14 characters long, but there are
actually 15 characters there, as confirmed by the length result. This weird
extra character seems to have the unicode hex value of f87f and appears in
various positions (not just the end) of text. I want to remove it, but can't
figure out how.
I've tried:
replace("Name", x'f87f', '') but it doesn't seem to match the weird character.
Any ideas?
Thanks,
Tom
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
