Results 1 to 2 of 2

Thread: Alpha Numeric

  1. #1

    Default Alpha Numeric

    Hello,

    Is there a way to do a wild character search for A-Z and 1-0, ineed to determine if a field is both alpha and numeric and exclude anything that's only alpha or only numeric or null. The function does not work because it also pics up numbers only as alpha numeric.


    Thank you.

  2. #2
    Lavastorm Employee
    Join Date
    Nov 2012
    Location
    Warrington, UK
    Posts
    221

    Default

    Below is an example of how to filter/split records that have values which are strictly Alphanumeric from Alpha only, Numeric only and Null values. Copy the code onto the BRE canvas.

    Code:
    node:Split
    bretype:core::Split
    editor:sortkey=59e722a13b4118fa
    input:@40fd2c74167f1ca2/=Static_Data.40fe6c55598828e5
    output:@40fd2c7420761db6/=
    output:@456df11556bd6bcf/=
    prop:PredicateExpr=<<EOX
    Data.isAlphaNum() and  not(Data.isNumber() or Data.isAlpha())
    EOX
    editor:XY=460,210
    end:Split
    
    node:Static_Data
    bretype:core::Static Data
    editor:sortkey=59e71e07330058fe
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    Data
    Hi123
    Hello
    2017Expo
    Howdy!
    NULL
    2017
    EOX
    editor:XY=280,120
    end:Static_Data
    
    node:Filter
    bretype:core::Filter
    editor:sortkey=59e71e117bb22477
    input:@40fd2c74167f1ca2/=Static_Data.40fe6c55598828e5
    output:@40fd2c7420761db6/=
    prop:Script=<<EOX
    #Match_Alpha_Only = Data.isAlpha()
    #Match_Num_Only = Data.isNumber()
    #Match_AlphaNum = Data.isAlphaNum()
    
    Match_AlphaNumeric_Strict = Data.isAlphaNum() and  not(Data.isNumber() or Data.isAlpha())
    
    emit * where Match_AlphaNumeric_Strict
    EOX
    editor:XY=460,120
    end:Filter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •