Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Character length
    1. Duplicate the barcode column
    2. Edit the formula to
      CHAR_LENGTH("Physical Item Details"."Barcode") 
    3. In Filters, filter on
      CHAR_LENGTH(Barcode) is not equal to / is not in  14
  2. Contains non-numeric characters
    1. Duplicate the barcode column
    2. Edit the formula to
      evaluate('REGEXP_INSTR(%1, ''^[0-9]+$'')',"Physical Item Details"."Barcode") 
    3. In Filters, filter on
      EVALUATE('REGEXP_INSTR(%1, ''^[... is equal to / is in  0
  3. Barcodes that do not start with 39074 (this applies to Main campus; Ginsburg barcodes may start with 32875; other campuses may have other expected barcode prefixes)
    1. Duplicate the barcode column
    2. Edit the formula to
      SUBSTRING("Physical Item Details"."Barcode" FROM 0 FOR 5)
    3. In Filters, filter on
      SUBSTRING(Barcode FROM 0 FOR 5) is not equal to / is not in  39074