Versions Compared

Old Version 3

changes.mady.by.user Leanne Finnigan

Saved on

compared with

New Version Current

changes.mady.by.user Holly Tomren

Saved on

Key

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

MIGRATED TO ONEDRIVE: Replacing+User+IDs+with+cataloger+initials+in+Analytics


Use case: In the "Modified by" column, I want to be able to see a catalogers' initials rather than their user ID.

...

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("Physical Item Details"."Modified By",'902298925910135016','MHHN'),'915144202','LF'),'908663101','CDC'),'909413966','MRTL'),'915252914','MKD'),'910061693','CP'),'907604594915628432','YLHT'),'915628432909818183','HTEL'),'915802314916241818', 'AMEGC')


You can add replacement functions to this by appending ,('USERID','INITIALS') and prepending REPLACE(