[OPEN-ILS-DEV] Removing URLS from 856

[Tim Spindler]

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&amp;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&amp;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, &amp; staff
only)</subfield><subfield code="u">
http://ezqc.ez.cwmars.org:5200/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=19277&amp;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&amp;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, &amp; staff
only)</subfield><subfield code="u">
http://ezqc.ez.cwmars.org:5200/login?url=http://digital.films.com/PortalPlaylists.aspx?aid=19277&amp;xtid=152</subfield><subfield
code="9">QCC</subfield></datafield>


-- 
Tim Spindler
tjspindler at gmail.com

*P**   Go Green - **Save a tree! Please don't print this e-mail unless it's
really necessary.*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20130402/c9b3e3ae/attachment.htm>