2 replies to this topic

[Rick Landrum]

Is there a way to use "search and replace" for Source List titles for sources that are basically duplicated because of the way they were entered? (I have many many sources).

 

Example:

 

U.S., XXXXXXXXX, or U.S. XXXXXXXX   vs   US XXXXXXX

 

These type of entries make selecting an existing source difficult because of the way that they sort.

[sloppy entry housekeeping....I know  ]

 

To individually change them is very time consuming. "Search and Replace" does not seem to give you any options for sources.

 

After editing them I would then also be able to merge duplicates.

 

Any help/hints would be appreciated.

 

Thanks

Rick

[zhangrau]

I do this type of cleanup by manually editing the errant Master Source names so that they appear sequentially under my preferred name & spelling. Then I manually merge them. One consideration is that any notes in the Master text - Source Text or Source Comments DOES NOT get merged using either an Automatic or Manual merge. Those need to be manually copied from the errant master source items into the compiled master source item.

 

Also, I am a bit leery of using automatic merges. They offer a potential speed up of operations, but reduce my input. I don't think I'm OCD about it, I just don't want to make a merging mistake that becomes a nightmare to undo.

[TomH]

You could use a SQLite manager to do bulk modification of source names.