Sorry for lack of clarity. By question marks, I meant- that some text, like Dutch programmers names, and address in Nordic locations, have accents and umaults and other such modifications done to English-alphabets. These get displayed as ? or box
On Sat, Jan 18, 2020, 16:34 Clemens Ladisch <clem...@ladisch.de> wrote: > Rocky Ji wrote: > > I am asked to highlight rows containing strange characters. All data were > > ingested by a proprietary crawler. > > > > By strange, I mean, question marks, boxes, little Christmas Trees, solid > > arrows, etc. kind of symbols; these appear suddenly in flow of normal > ASCII > > English letters. > > GLOB supports character classes: > > SELECT * > FROM MyTable > WHERE DataField GLOB '*[^ -~]*'; > > Question marks _are_ ASCII characters. If you want to allow fewer > characters, > list them: [^ A-Za-z0-9,.-] > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users