...
- Character length
- Duplicate the barcode column
- Edit the formula to
CHAR_LENGTH("Physical Item Details"."Barcode") - In Filters, filter on
CHAR_LENGTH(Barcode) is not equal to / is not in 14 - Contains non-numeric characters
- Duplicate the barcode column
- Edit the formula to
evaluate('REGEXP_INSTR(%1, ''^[0-9]+$'')',"Physical Item Details"."Barcode") - In Filters, filter on
EVALUATE('REGEXP_INSTR(%1, ''^[... is equal to / is in 0 - 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)
- Duplicate the barcode column
- Edit the formula to
SUBSTRING("Physical Item Details"."Barcode" FROM 0 FOR 5) - In Filters, filter on
SUBSTRING(Barcode FROM 0 FOR 5) is not equal to / is not in 39074