Skip to main content
Question

select which is containing special char

rakeshreddy0996
Forum|alt.badge.img

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.

    2 replies

    D
    Forum|alt.badge.img
    • danullen
    • January 17, 2020

    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.

    ebygomm
    Influencer
    Forum|alt.badge.img+33
    • ebygommInfluencer
    • Influencer
    • January 17, 2020

    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]

    Reply


    Helpful Members This Week

    Community Stats

    31,172
    Posts
    118,157
    Replies
    38,788
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.