RE: Global updating commas in patron records

["West, Barbara - HPL" <Barbara.West@xxxxxxxxxx>]

Try telling MilCat to find \,  (a backslash followed by a comma, no spaces)
and to replace it with nothing, not even a space.  Leave the "replace" data
box empty.

-----Original Message-----
From: Laura Gallucci [mailto:Laura_Gallucci@xxxxxxxxxx]
Sent: Friday, July 18, 2003 3:30 PM
To: innopac@xxxxxxxxxx
Subject: Global updating commas in patron records


	In working with a more refined authentication system for our
databases I am faced with the problem of refining the conformity of the name
field in our patron records.  The format needs to be Last name, first name.
I have several thousand records
that do not have the comma in between the names.
	I know I can do this in Millennium Global update if I enter the
right regular expression.  I cannot seem to find what that expression is.
The closest I can get is to replace all the spaces with commas, which is no
good. I would be most grateful if
anyone has any suggestions.  Thank you.   

Regards, 

Laura Gallucci, M.L.S.
URSUS Library Systems Manager
Raymond H. Fogler Library
University of Maine, Orono
Ph#: 207-581-1687
E-mail: laura.gallucci@xxxxxxxxxx

--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC@xxxxxxxxxx
Update your subscription options:
http://innopacusers.org/list/listinfo/innopac