LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Alpha Numeric

    Employee
    Posted 10-17-2017 08:10

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: komskex

    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.  RE: Alpha Numeric

    Employee
    Posted 10-18-2017 02:51

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    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