Alpha Numeric

Follow

Infogix Support

• October 17, 2017 15:10

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.

0

• 

  Infogix Support

  • October 18, 2017 09:51

  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.