We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

Alpha Numeric

Comments

1 comment

  • Avatar
    Infogix Support
    Originally posted by: awilliams1024

    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.

    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
    0
    Comment actions Permalink

Please sign in to leave a comment.