We have a library that wants to reload its Films on Demand records. These records have multiple 856s for other institutions with the subfield 9 associated with their shortname. What would the best way be to remove these for instance. I have created a list of the records needing updating in the staging table. Here is an example of the of he 856. I have code that can remove all the 856s but am having trouble removing just one. We just want to remove the one for HCC (although I'll take suggests for removing the duplicate QCC lines also)
<datafield tag="856" ind1="4" ind2="0"><subfield code="y">Click here to access this film online (MCLA students, faculty, and staff only)</subfield><subfield code="u"> http://libproxy.mcla.edu:2048/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=11580&xtid=152</subfield><subfield code="9">MCLA</subfield></datafield> <datafield tag="856" ind1="4" ind2="0"><subfield code="u"> http://ezhc.ez.cwmars.org:4000/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=9206&xtid=152</subfield><subfield code="y">Click here to access this film online (HCC Students and Staff only)</subfield><subfield code="9">HCC</subfield></datafield> <datafield tag="856" ind1="4" ind2="0"><subfield code="y">Click here to access this film online (QCC studetns, faculty, & staff only)</subfield><subfield code="u"> http://ezqc.ez.cwmars.org:5200/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=19277&xtid=152</subfield><subfield code="9">QCC</subfield></datafield> <datafield tag="856" ind1="4" ind2="0"><subfield code="u"> http://ezhc.ez.cwmars.org:4000/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=9206&xtid=152</subfield><subfield code="y">Click here to access this film online (HCC Students and Staff only)</subfield><subfield code="9">HCC</subfield></datafield> <datafield tag="856" ind1="4" ind2="0"><subfield code="y">Click here to access this film online (QCC studetns, faculty, & staff only)</subfield><subfield code="u"> http://ezqc.ez.cwmars.org:5200/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=19277&xtid=152</subfield><subfield code="9">QCC</subfield></datafield> -- Tim Spindler [email protected] *P** Go Green - **Save a tree! Please don't print this e-mail unless it's really necessary.*
