Page Comparison

...

1. Include Bibliographic Details - Local Param 02 as a column in the Details tab
2. In the menu options for Local Param 02, choose "edit formula"
3. Click the f(...) button to Insert Function
4. Navigate to String → Substring and click OK. You will now see the syntax SUBSTRING("Bibliographic Details"."Local Param 02" FROM startPos FOR length)
5. We want the first 8 characters after the $$a (skip the first 4 characters), so edit the last part to FROM 0 5 to 8 and click OK. You can also rename the column to something like "CAT DATE"

Once the Cataloging Date is available in its own column you can filter data to get a report of records cataloged during a given date range, such as between 20170701 and 20180630 to report on FY18. Note that this only works from July 2017 forward (post Alma implementation).

Isolating MARC Subfields

Ex Libris now includes MARC subfields in Analytics Local Parameters. Particularly for Local Param 02, it is possible to split this field into separate columns by subfield.

Function: Evaluate('regexp_substr(%1,%2,%3,%4,%5,%6)', "Bibliographic Details"."Local Param 02", '\$\$a([^\$]+)', 1, 1, NULL, 1)

(Replace 'a' with other letters to isolate a different subfield.)

Filtering a Report to Specific IDs

...