Re: [LegacyUG] Find/Replace Address Data
Thanks to Bob and Sherry. I used a combination of both solutions and things look much better. On Mon, Oct 6, 2014 at 4:24 PM, Sherry/Support wrote: > In the Master Location List, go to Options > Expand/Contract Location > Parts. > > There's a selection to expand the locations, which will change TX to Texas. > > However you must have those locations in the four part format of > city/town, county, state, country, with commas for missing elements > otherwise this feature won't find them all correctly. > > You don't need to back up because you can undo by contracting location > parts . > > However, Bob gave some good info on the Search Replace feature, including > the backup warning and confirming each change. > > > Sincerely, > Sherry > Technical Support > Legacy Family Tree > > On Mon, Oct 6, 2014 at 12:21 PM, Rick Koelz wrote: > >> Is there a way to do a FIND and REPLACE on my Master Locations? >> Such as replace all the TX values with Texas. >> Thanks >> > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages after Nov. 21 2009: > http://www.mail-archive.com/legacyusergroup@legacyusers.com/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and > on our blog (http://news.LegacyFamilyTree.com). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Find/Replace Address Data
In the Master Location List, go to Options > Expand/Contract Location Parts. There's a selection to expand the locations, which will change TX to Texas. However you must have those locations in the four part format of city/town, county, state, country, with commas for missing elements otherwise this feature won't find them all correctly. You don't need to back up because you can undo by contracting location parts . However, Bob gave some good info on the Search Replace feature, including the backup warning and confirming each change. Sincerely, Sherry Technical Support Legacy Family Tree On Mon, Oct 6, 2014 at 12:21 PM, Rick Koelz wrote: > Is there a way to do a FIND and REPLACE on my Master Locations? > Such as replace all the TX values with Texas. > Thanks > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] Find/Replace Address Data
Hi Rick, In the simplest form (read my caution)... Go to "Search/Search Replace". In the pop up window... Find where: Lists-Location Find what: TX Replacement Text: Texas Anywhere in the field Replace only found text with replacement test Caution: doing as above will work, however it could change every letter combination of tx to Texas. I prefer to be more specific by... Find what: , TX Replacement text: , Texas or: , TX, USA to , Texas, USA then I'm pretty sure to get the results I want. You may want to do the same in List-Location Short, although many will leave the TX in the short version of the location. TX is fairly safe, as there aren't many words with that combination. If you were doing OH you could get Ohioio, as the Oh in Ohio has been replaced with Ohio. As in: replace "IN" with "Indiana" and get " IllIndianaois ". I think you see the need to think it through before doing the replacement. Another caution, as with any of these significant operations - do a back up first. Bob From: Rick Koelz [mailto:r...@koelz.com] Sent: Monday, October 06, 2014 12:21 PM To: legacyusergroup@LegacyUsers.com Subject: [LegacyUG] Find/Replace Address Data Is there a way to do a FIND and REPLACE on my Master Locations? Such as replace all the TX values with Texas. Thanks Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] Find/Replace Address Data
I don’t know of any “Find and Replace” for the Master Location list. You’d probably just have to SORT… and then move the STATE to the top of the list and then scroll down on your list until you find all the TX locations together. Then EDIT each one to TEXAS. Brian in CA From: Rick Koelz [mailto:r...@koelz.com] Sent: Monday, October 06, 2014 12:21 PM To: legacyusergroup@LegacyUsers.com Subject: [LegacyUG] Find/Replace Address Data Is there a way to do a FIND and REPLACE on my Master Locations? Such as replace all the TX values with Texas. Thanks Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
[LegacyUG] Find/Replace Address Data
Is there a way to do a FIND and REPLACE on my Master Locations? Such as replace all the TX values with Texas. Thanks Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp