Question

select which is containing special char

i have name with special characters so i need to select which is containing special characters.

NamesÇaõeshLoõeshNaveeõSaÇdaÇNaggattuHigh way 54Local-Street

Select like yellow highlighted data only

Note Exclude:

Pure numeric

Pure Alphabets

Combination of Alphabets, numeric and Spaces

combination of Alphabets, numeric and hi-fen.

The regex [^a-zA-Z0-9 -] will give you hits on anything that is not a regular letter, a digit, a hyphen or a space.

Userlevel 1

+21

I would use the following regex in a stringsearcher to match non English letters, the records highlighted in yellow would come out the matched port

[^\x00-\x7F]

Sign up