Gossamer Forum
Home : Products : DBMan : Customization :

modifying multiple fields

Quote Reply
modifying multiple fields
Is there a mod available that will allow me to select and modify a particular record, then once I commit the change, will search out all other records in the database with the same contents of the field I just changed and change only that field in all other records?

For example, I have a list of books. They have various titles and some authors have more than one book listed. I discover that I have misspelled the author's name. When I change the name of the author to reflect the proper spelling in one record, I want the database to find and correct all occurances of that misspelled name in the "name" field in the rest of the records which have it misspelled also.

I know this is getting dangerously close to needing a relational database.

Thanks

Wes
Quote Reply
Re: [kd4rdb] modifying multiple fields In reply to
maybe not the best solution for what you are trying to do but take a look at the CSVdb program at http://home.hccnet.nl/...oftware/software.htm

I have used it sucessfully to make changes.

Or you could just down load your file and use the find and replace function of your text editor ( see http://www.fixedsys.com/context/ ). Then upload

I'm sure I don't need to remind you to keep a good backup regardles of how you make the changes.


Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
Quote Reply
Re: [kd4rdb] modifying multiple fields In reply to
In Reply To:
I know this is getting dangerously close to needing a relational database
DBMan can be used as a relational database. See JPDeni's DBMan Mods.

The relational database mod is more of a tutorial than a mod (it's about 3/4 of the way down that page). I strongly suggest reading it if you have repeating values in your fields.