On 9/20/06, IAIN GALLAGHER <[EMAIL PROTECTED]> wrote:
I have a database of scientific references. In that database there is a table
(bibref) containing a field (Author). I would like to search for ampersand (&)
and replace it with a semicolon (;) in the Author field.
How do I do this?
The simplest way:
export the database to a text file.
Use the search and replace function of a text editor. (you may need to
use regular expressions to avoid editing the contents of other fields)
Import the text file back to a database.
alternatively:
write a program to retrieve, edit, and update that field.
--
--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite
Cthulhu Bucks!
http://www.cthulhubucks.com
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
