Re: [IUG] question on global update need for patron record field

["Shirley Lincicum" <shirley dot lincicum at gmail dot com>]

Al,

You could make a copy of the e-mail field in all of the patron records
using the Copy variable-length field option in Global update. Then,
you could go back in with global update and modify the second copy of
the field (change the field tag, replace @wsu.edu with a <blank>
character, etc.) This should work well for e-mail addresses in the
same domain (e.g. @wsu.edu). You will have more trouble using this
approach if the domain varies a lot between records because I don't
think you can use regular expressions to do Global updates.

Just one idea,

Shirley

-- 
Shirley Lincicum
Collection Management Librarian
Hamersly Library
Western Oregon University
Monmouth, OR 97361

On Dec 6, 2007 1:41 PM, Cornish, Alan K <cornish at wsu dot edu> wrote:
> Hello all,
>
>
>
> Running Millennium Release 2006 1.3.  I need to populate a patron record
> field which is empty, with a subset of data from another patron record
> field.  I'm interested in knowing if any other III libraries have
> performed this type of work.  Specific case:
>
>
>
> Existing field value; this needs to remain in place:
>
> E-mail address:  jqpublic at wsu dot edu
>
>
>
> Desired field value: this needs to be added:
>
> User name:  jqpublic
>
>
>
> In short, I want to keep the existing patron record field and its value
> in place, and to populate an existing, but empty field with a subset of
> the data in the existing field (which is everything before an '@' sign).
>
>
>
> I'm not sure that this is possible, using a function such as Global
> Update, but I wanted to check to see if any users have done this kind of
> maintenance work before.  Thanks!
>
>
>
> Al Cornish
>
> Head, Library Systems
>
> Washington State University Libraries
>
>
>
> 509.335.1895 (voice)
>
> cornish at wsu dot edu (e-mail)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
> --
> This message was distributed through the Innovative Users Group INNOPAC list
> Public replies:  INNOPAC at innopacusers dot org
> Update your subscription options: http://innopacusers.org/mailman/listinfo/innopac
>