John, Use the new Compare Databases routine to copy the information into you main data base. Here's the steps 1) Create a copy of your data base in another folder 2) Load BK 3) Go to File-->Utilities-->Compare two databases (down near the bottom) 4) Start the comparison and copy the events you want from the right to the left using the proper buttons. Jim Ps: Let BK do the work versus you;-) -----Original Message----- From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf Of John Bibby Sent: Thursday, January 05, 2012 4:23 AM To: bk@rootsweb.com Subject: [BK] Duplicate entries - two further ideas I wrote yesterday regarding duplicate entries. I got several responses all of which said that basically the method outlines on p.67 is the only way to deal with it. (Decide which one you want to keep; copy all info over from the other; then delete the other.) I do this - but generally I rename the 'deleted' one "John deleted Smith", so it is still there just in case I make a mistook. However, two other possibilities have occurred to me: 1. Can I export GEDCOMs for the two relevant items; then edit the GEDCOMs in some clever way (I don;t know how); then import the GEDCOM which will give just one individual obatined by merging the other two. 2. Would it be possible in future to have an "Is identical to" relation? This would keep them as two records but would regard them as one individual. Any comments please on the feasibility of the above? JOHN B ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

I wrote yesterday regarding duplicate entries. I got several responses all of which said that basically the method outlines on p.67 is the only way to deal with it. (Decide which one you want to keep; copy all info over from the other; then delete the other.) I do this - but generally I rename the 'deleted' one "John deleted Smith", so it is still there just in case I make a mistook. However, two other possibilities have occurred to me: 1. Can I export GEDCOMs for the two relevant items; then edit the GEDCOMs in some clever way (I don;t know how); then import the GEDCOM which will give just one individual obatined by merging the other two. 2. Would it be possible in future to have an "Is identical to" relation? This would keep them as two records but would regard them as one individual. Any comments please on the feasibility of the above? JOHN B

Hi John, Look at both entries for the duplicated person, see which one has the most information on it. Write down the information from the second entry that is not on the first entry. Check the links for parents, spouse and children. If there are any to person 2 (that is going to be deleted) write down the BK code number for them. And the details of the marriage if you are deleting a marriage. Once all this has been done, go to the person you are going to delete, choose delete link to spouse from the Delete menu, if there is a spouse to delete, then select delete person. Now go to the entry being kept and remake any links that you have deleted to parents, spouse or children by choosing the appropriate add option then entering the BK code number that you previously recorded. Add in any other information you have recorded from the deleted entry. This process is used when only one person has been duplicated. If there is a family or line, then it is the same basic process but you have to expand it to include everyone that is duplicated. If you have a large family to delete and you want to print out information before doing the deletes then use a group sheet and include all the fields that you use in your database. Just print out the descendants of the oldest person in the family group you are needing to delete. Make sure you have a good backup of your database before you start doing this process in case something goes wrong. You can use the compare database routine by making a copy of your database and giving it a new name, then run the compare routine. However, once you compare the data you will still need to manually delete the marriage then person who is duplicated as above. Hope this helps. Bye Karlena -----Original Message----- From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf Of John Bibby Sent: Wednesday, 4 January 2012 10:48 PM To: bk@rootsweb.com Subject: [BK] Duplicate people I have several duplicate people on my database i.e. two records AS1 and AS2 for the same person AS. AS1 and AS2 both have lots of information and links. I want to get a new record which merges all this information. What is the best way of dealing with this? The guidance given on p.67 of the manual is not very helpful here. (If I had to delete one, it's not even clear to me which of A1 and A2 is best to delete.) Is there any way of printing out all the info and links for AS1 and AS2 so that I can compare them? JOHN BIBBU ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1901 / Virus Database: 2109/4721 - Release Date: 01/03/12

Dear John Bibby, It depends of the sources. If I have a birthcertificate, for a birthdate than I accepts that information. Sometimes that birthdate deviates from the information on the deathcertificate. If for a event two dates are availeble from both equal reliable sources than I give both dates with the opportunity "between" or with ABT (about). With my best regards, Max van Dam Rechovot Israel http://www.maxvandam.info/ ----- Original Message ----- From: John Bibby To: bk@rootsweb.com Sent: Wednesday, January 04, 2012 1:50 PM Subject: [BK] Conflicting data How do people deal with conflicting data? e.g. different sources give different birth dates for AS? JOHN ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

At 01:50 PM 1/4/2012, John Bibby wrote: >How do people deal with conflicting data? e.g. different sources >give different birth dates for AS? I use multiple source entries for the multiple sources, assign each one a number under "Quality of data" corresponding to its reliability, and arrange the sources for each event with the most reliable at the top and the least reliable at the bottom. Dale H. Cook, Member, NEHGS and MA Society of Mayflower Descendants; Plymouth Co. MA Coordinator for the USGenWeb Project Administrator of http://plymouthcolony.net

On Wed, 4 Jan 2012 11:50:31 +0000, John Bibby <johnbibbyjohnbibby@gmail.com> wrote: >How do people deal with conflicting data? e.g. different sources give >different birth dates for AS? > What er your main datasource? Make that as the safe data-information. Add the other date as note to the event. You can then in the Note add the source for the second information. (might John make it possible to have source as att. to a Note?b ) -- Otto Jørgensen http://www.bkwin.info/ All email is checked by NORTON

On Wed, 4 Jan 2012 11:48:24 +0000, John Bibby <johnbibbyjohnbibby@gmail.com> wrote: >I have several duplicate people on my database i.e. two records AS1 and AS2 >for the same person AS. > >AS1 and AS2 both have lots of information and links. I want to get a new >record which merges all this information. > >What is the best way of dealing with this? > >The guidance given on p.67 of the manual is not very helpful here. (If I >had to delete one, it's not even clear to me which of A1 and A2 is best to >delete.) > >Is there any way of printing out all the info and links for AS1 and AS2 so >that I can compare them? Best way depends on your database. You can locatate those who are double, Flagg one line and work from there You can use the new facilities to compare two databases and the see what to delete. Anyway it is a job that can take time -- Otto Jørgensen http://www.bkwin.info/ All email is checked by NORTON

How do people deal with conflicting data? e.g. different sources give different birth dates for AS? JOHN

I have several duplicate people on my database i.e. two records AS1 and AS2 for the same person AS. AS1 and AS2 both have lots of information and links. I want to get a new record which merges all this information. What is the best way of dealing with this? The guidance given on p.67 of the manual is not very helpful here. (If I had to delete one, it's not even clear to me which of A1 and A2 is best to delete.) Is there any way of printing out all the info and links for AS1 and AS2 so that I can compare them? JOHN BIBBU

I like to see on main screen that I have multiple info so just add second entry to the grid for birth date with each having a different date and source. I put entry with most reliable source on top. BK seems to use the top entry for age calculations. On 1/4/2012 6:50 AM, John Bibby wrote: > How do people deal with conflicting data? e.g. different sources give > different birth dates for AS? > > JOHN > > ------------------------------- > To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message > >

I would print an individual sheet, making sure that BK numbers were turned on. Do it for both copies of the duplicated person. Compare info and links, delete one, and add info to the other. Jack in SW Ohio On Wed, Jan 4, 2012 at 8:08 AM, Karlena Lockett <karlena@iprimus.com.au>wrote: > Hi John, > Look at both entries for the duplicated person, see which one has the most > information on it. Write down the information from the second entry that is > not on the first entry. Check the links for parents, spouse and children. > If > there are any to person 2 (that is going to be deleted) write down the BK > code number for them. And the details of the marriage if you are deleting a > marriage. Once all this has been done, go to the person you are going to > delete, choose delete link to spouse from the Delete menu, if there is a > spouse to delete, then select delete person. Now go to the entry being kept > and remake any links that you have deleted to parents, spouse or children > by > choosing the appropriate add option then entering the BK code number that > you previously recorded. Add in any other information you have recorded > from > the deleted entry. This process is used when only one person has been > duplicated. If there is a family or line, then it is the same basic process > but you have to expand it to include everyone that is duplicated. > If you have a large family to delete and you want to print out information > before doing the deletes then use a group sheet and include all the fields > that you use in your database. Just print out the descendants of the oldest > person in the family group you are needing to delete. > Make sure you have a good backup of your database before you start doing > this process in case something goes wrong. You can use the compare database > routine by making a copy of your database and giving it a new name, then > run > the compare routine. However, once you compare the data you will still need > to manually delete the marriage then person who is duplicated as above. > > Hope this helps. > Bye Karlena > -----Original Message----- > From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf > Of > John Bibby > Sent: Wednesday, 4 January 2012 10:48 PM > To: bk@rootsweb.com > Subject: [BK] Duplicate people > > I have several duplicate people on my database i.e. two records AS1 and AS2 > for the same person AS. > > AS1 and AS2 both have lots of information and links. I want to get a new > record which merges all this information. > > What is the best way of dealing with this? > > The guidance given on p.67 of the manual is not very helpful here. (If I > had > to delete one, it's not even clear to me which of A1 and A2 is best to > delete.) > > Is there any way of printing out all the info and links for AS1 and AS2 so > that I can compare them? > > JOHN BIBBU > > ------------------------------- > To unsubscribe from the list, please send an email to > BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in > the subject and the body of the message > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2012.0.1901 / Virus Database: 2109/4721 - Release Date: 01/03/12 > > > ------------------------------- > To unsubscribe from the list, please send an email to > BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in > the subject and the body of the message >

On Mon, 2 Jan 2012 21:02:06 -0500, Jim Ramaley wrote: Thank you everyone helping me. Have to gather all the lose ends and try to go for a way to solve the situation I have got into when I in 2007 in a hurry made a gedcom for BK and not actually checked it for unwanted information. Worse of it; I have learned, In the old program there is a box to tick and I had never got this problem. :-( John Steed point on a way to dele/change the content of those events notes. But it do not delete the notes completely. I still have the indication N for notes on the Event/fact screen, even if the event note is empty. Then I do not get any further, to easily see when there is information in the note field. Nice to know the opportunity, but I'm not sure I'm going for it. Then the next try is in some way clean a Gedcom. Most of the notes says: Sesetive:0 But there can be additional text that have to be kept. When I am writing this I came up with an idea to use John Steed way about to clean all those events notes. When it was done with a test database. I made a new gedcom from a test database and all the empty notes was gone. This looks promising, Have to do some more tests to find out if this is a safe way to do this. Probably worth the try. Jostein >Nope, >I just checked it. You are replacing 2 CRs with 1. (and the intervening text) >Jim R > ----- Original Message ----- > From: Jim Dell > To: bk@rootsweb.com > Sent: Monday, January 02, 2012 8:57 PM > Subject: Re: [BK] Cleaning my database -- without macros > > > Jim, > I think that creates the blank lines he mentioned. > > Jim Dell > > -----Original Message----- > From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf Of > Jim Ramaley > Sent: Monday, January 02, 2012 8:46 PM > To: bk@rootsweb.com > Subject: Re: [BK] Cleaning my database -- without macros > > Jostein, > > MS-WORD actually does allow you to search for an replace carriage returns > without needing a macro. > > The key is that the carriage return can be represented by ^p (^ is the > carat symbol; shift 6 on my keyboard) > > Open your Gedcom (which is essentially a text file) in Word. > 1 Go to the find & replace dialog. > 2. In the FIND box put ^p2 NOTE Sensitive:0^p 3. In the REPLACE box put > ^p. > 4. Replace all occurrences > 5. Save the file as a txt file (use the SAVE AS dialog) > > The resulting file is what you want. Treat it as a GEDCOM. > > Jim R > Gettysburg, PA > > > > > ----- Original Message ----- > From: Jim Dell > To: bk@rootsweb.com > Sent: Monday, January 02, 2012 3:58 PM > Subject: Re: [BK] Cleaning my database? > > > Here's the basis of a quick and dirty MS Word macro that will delete a > line > beginning with > "2 NOTE Sensitive:" > > Begin: > Selection.Find.ClearFormatting > With Selection.Find > .Text = "2 NOTE Sensitive:" > .Replacement.Text = "" > .Forward = True > .Wrap = wdFindAsk > .Format = False > .MatchCase = False > .MatchWholeWord = False > .MatchWildcards = False > .MatchSoundsLike = False > .MatchAllWordForms = False > End With > Selection.Find.Execute > Selection.Extend > Selection.Extend > Selection.Extend > Selection.Delete Unit:=wdCharacter, Count:=1 > End Sub > > More work is need to make it go through the entire GEDCOM automatically. > > Jim > > -----Original Message----- > From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf > Of > Jostein Fauske > Sent: Monday, January 02, 2012 10:30 AM > To: bk@rootsweb.com > Subject: Re: [BK] Cleaning my database? > > On Mon, 2 Jan 2012 10:03:06 -0500, Jim Dell wrote: > > Jim, > Thank you for the offer. The information is not sensitive, but have got > this > notes added by my previous program. > > 1 SEX M > 1 BIRT > 2 DATE 13 NOV 1852 > 2 PLAC Aamodt, Gaular, NORWAY > 2 SOUR @S5@ > 2 NOTE Sensitive:0 > 1 DEAT > 2 DATE 1940 > 2 NOTE Sensitive:0 > 1 DEAT > 2 DATE 1940 > 2 PLAC F²rde, Norway > 2 NOTE Sensitive:0 > 1 BURI > 2 DATE 1940 > 2 PLAC Norway > 2 NOTE Sensitive:0 > 1 OCCU Farmer > 2 NOTE Sensitive:0 > > Her is a short portion of the gedcom. Every line with "Sensetive:0" is not > need and have to be deleted completely. > > >Jostein, > >Post a portion of the GEDCOM file with the sensitive data (you can > >change it in the example if it's too sensitive) with the GEDCOM lines > >before and after it and let me see if I can offer some suggestions. > > > >Jim > > > >-----Original Message----- > >From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On > >Behalf Of Jostein Fauske > >Sent: Monday, January 02, 2012 9:42 AM > >To: bk@rootsweb.com > >Subject: Re: [BK] Cleaning my database? > > > >On Sun, 1 Jan 2012 13:11:20 -0500, Jack Ray wrote: > > > >I have tried with a test gedcom, but I have not found a way to do a > >"find and replace" that do not leave a empty line. Maybe I do not know > >my word processor enough . (Open Office) I'm talking about over 3000 > >entries that have to be changed so I need a automated way to do the > editing. > > > > > >>The only way I can think to do it, is to put a gedcom into a word > >>processor and do a search for "Sensitive:0" then deletye the note. > >> > >>Jack in Ohio > >> > >>On Sun, Jan 1, 2012 at 12:37 PM, Jostein Fauske > ><jostein.fauske@c2i.net>wrote: > >> > >>> Hi! > >>> When I imported my database into BK I got some information that was > >>> not wanted. My previous program had the opportunity to set an event > >>> as sensitive or not. > >>> This information followed the gedcom file as a note to each event. I > >>> want to delete all notes that looks like this: Sensitive:0 Is there > >>> any way to delete this note from the database without opening every > >>> person and delete it manually? > >>> > >>> > >>> -- > >>> Jostein Fauske > >>> N-6977 BYGSTAD,Norway > >>> mailto:jostein.fauske@c2i.net > >>> http://www.zet.no/~josteinf/ > >>> > >>> > >>> > >>> ------------------------------- > >>> To unsubscribe from the list, please send an email to > >>> BK-request@rootsweb.com with the word 'unsubscribe' without the > >>> quotes in the subject and the body of the message > >>> > >> > >>------------------------------- > >>To unsubscribe from the list, please send an email to > >>BK-request@rootsweb.com with the word 'unsubscribe' without the quotes > >>in the subject and the body of the message > > > > > >------------------------------- > >To unsubscribe from the list, please send an email to > >BK-request@rootsweb.com with the word 'unsubscribe' without the quotes > >in the subject and the body of the message > > > > > >------------------------------- > >To unsubscribe from the list, please send an email to > >BK-request@rootsweb.com with the word 'unsubscribe' without the quotes > >in the subject and the body of the message > > -- > Jostein Fauske > N-6977 BYGSTAD,Norway > mailto:jostein.fauske@c2i.net > http://www.zet.no/~josteinf/ > > > > ------------------------------- > To unsubscribe from the list, please send an email to > BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in > the subject and the body of the message > > > > ------------------------------- > To unsubscribe from the list, please send an email to > BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in > the subject and the body of the message > > ------------------------------- > To unsubscribe from the list, please send an email to > BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in > the subject and the body of the message > > > > ------------------------------- > To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message > >------------------------------- >To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message -- Jostein Fauske N-6977 BYGSTAD,Norway mailto:jostein.fauske@c2i.net http://www.zet.no/~josteinf/

On further reflection, I think Jim Remaly's method of using Word is the best way to go. Whatever you do, make sure you have at least one backup before you start. Effectus bonus addo bonus On Jan 3, 2012, at 12:11 PM, Jostein Fauske <jostein.fauske@c2i.net> wrote: > On Mon, 2 Jan 2012 21:02:06 -0500, Jim Ramaley wrote: > > Thank you everyone helping me. > Have to gather all the lose ends and try to go for a way to solve the > situation I have got into when I in 2007 in a hurry made a gedcom for > BK and not actually checked it for unwanted information. Worse of it; > I have learned, In the old program there is a box to tick and I had > never got this problem. :-( > John Steed point on a way to dele/change the content of those events > notes. But it do not delete the notes completely. I still have the > indication N for notes on the Event/fact screen, even if the event > note is empty. Then I do not get any further, to easily see when > there is information in the note field. Nice to know the opportunity, > but I'm not sure I'm going for it. > Then the next try is in some way clean a Gedcom. > Most of the notes says: Sesetive:0 > But there can be additional text that have to be kept. > > When I am writing this I came up with an idea to use John Steed way > about to clean all those events notes. When it was done with a test > database. I made a new gedcom from a test database and all the empty > notes was gone. This looks promising, Have to do some more tests to > find out if this is a safe way to do this. Probably worth the try. > > Jostein > > >> Nope, >> I just checked it. You are replacing 2 CRs with 1. (and the intervening text) >> Jim R >> ----- Original Message ----- >> From: Jim Dell >> To: bk@rootsweb.com

On Mon, 2 Jan 2012 18:57:16 -0500, David Youse wrote: I'll do a test and see if the "old horse are still running". The question is how the old program interpret the event notes from BK- gedcom. Today: The old program can't reverse those entries from a gedcom. It become treated as notes as suspected. Also "Status quo". Jostein >Not to beat a dead horse, but could you make a BK gedcom, export it to your old program, delete the unwanted data and then make a new gedcom to import back into BK? > > > > >Effectus bonus addo bonus > > > >On Jan 2, 2012, at 12:32 PM, Jostein Fauske <jostein.fauske@c2i.net> wrote: > >> On Mon, 2 Jan 2012 10:42:09 -0600, Bobby Richardson wrote: >> >> I think that is 3 years and 1000 new entries to late. So that is not >> actually an option. >> >>> It seems to me that since the problem is in the data generated by your >>> previous program, that's where you ought to look for a solution. Try to >>> find out how to generate a new GED file from that program without these >>> unwanted Notes. >>> >>> Bobby Richardson >>> >>> -----Original Message----- >>> >>> >>> Message: 1 >>> Date: Sun, 01 Jan 2012 18:37:36 +0100 >>> From: Jostein Fauske <jostein.fauske@c2i.net> >>> Subject: [BK] Cleaning my database? >>> To: bk@rootsweb.com >>> Message-ID: <tb61g79s0vtplat8ck5fu37kra32trqil8@4ax.com> >>> Content-Type: text/plain; charset=us-ascii >>> >>> Hi! >>> When I imported my database into BK I got some information that was not >>> wanted. My previous program had the opportunity to set an event as sensitive >>> or not. >>> This information followed the gedcom file as a note to each event. I want to >>> delete all notes that looks like this: Sensitive:0 Is there any way to >>> delete this note from the database without opening every person and delete >>> it manually? >> >> >> ------------------------------- >> To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message > > >------------------------------- >To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message -- Jostein Fauske N-6977 BYGSTAD,Norway mailto:jostein.fauske@c2i.net http://www.zet.no/~josteinf/

I like David's proposal, but I never feel confident that going into Excel and out again will behave exactly as I want. What is a good way fo checking that the output is correct? JOHN BIBBY On 3 January 2012 09:18, David Bartelt <dybartelt@comcast.net> wrote: > Corrected line below..... > ----- Original Message ----- > From: "David Bartelt" <dybartelt@comcast.net> > To: <bk@rootsweb.com> > Sent: Monday, January 02, 2012 10:00 AM > Subject: Re: [BK] Cleaning my database? > > > You could create a gedcom and open it with Notepad. > Then copy and paste from Notepad into Excel. > In Exce, create a 'number order' column with a number series 1 to whatever. > This is to preserve the original order of the lines of the Gedcom. > In Excel, sort on "Sensitive" and delete the approprite lines. > Resort using the 'number sort' column to get back to the original order. > REPLACE THIS ---> Create a Gedcom and use that to create another instance > of your Brother's > Keeper database. > WITH THIS ---> Copy only the column data from Excel, paste into Notepad, > change the file extension to .GED and you have your new cleaned gedcom. > Import into another instance of Brother's Keeper. > > But, be warned. Exporting and importing wll change other data. > > You are only talking some 3000 entries and it will take some time but it > wouldn't be that bad. > > David Bartelt > > ----- Original Message ----- > From: "Jostein Fauske" <jostein.fauske@c2i.net> > To: <bk@rootsweb.com> > Sent: Monday, January 02, 2012 9:29 AM > Subject: Re: [BK] Cleaning my database? > > > On Mon, 2 Jan 2012 10:03:06 -0500, Jim Dell wrote: > > Jim, > Thank you for the offer. The information is not sensitive, but have > got this notes added by my previous program. > > 1 SEX M > 1 BIRT > 2 DATE 13 NOV 1852 > 2 PLAC Aamodt, Gaular, NORWAY > 2 SOUR @S5@ > 2 NOTE Sensitive:0 > 1 DEAT > 2 DATE 1940 > 2 NOTE Sensitive:0 > 1 DEAT > 2 DATE 1940 > 2 PLAC F²rde, Norway > 2 NOTE Sensitive:0 > 1 BURI > 2 DATE 1940 > 2 PLAC Norway > 2 NOTE Sensitive:0 > 1 OCCU Farmer > 2 NOTE Sensitive:0 > > Her is a short portion of the gedcom. Every line with "Sensetive:0" is > not need and have to be deleted completely. > > >Jostein, > >Post a portion of the GEDCOM file with the sensitive data (you can change > >it > >in the example if it's too sensitive) with the GEDCOM lines before and > >after > >it and let me see if I can offer some suggestions. > > > >Jim > > > >-----Original Message----- > >From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf > Of > >Jostein Fauske > >Sent: Monday, January 02, 2012 9:42 AM > >To: bk@rootsweb.com > >Subject: Re: [BK] Cleaning my database? > > > >On Sun, 1 Jan 2012 13:11:20 -0500, Jack Ray wrote: > > > >I have tried with a test gedcom, but I have not found a way to do a "find > >and replace" that do not leave a empty line. Maybe I do not know my word > >processor enough . (Open Office) I'm talking about over 3000 entries that > >have to be changed so I need a automated way to do the editing. > > > > > jostein.fauske@c2i.net>wrote: > >> > >>> Hi! > >>> When I imported my database into BK I got some information that was > >>> not wanted. My previous program had the opportunity to set an event > >>> as sensitive or not. > >>> This information followed the gedcom file as a note to each event. I > >>> want to delete all notes that looks like this: Sensitive:0 Is there > >>> any way to delete this note from the database without opening every > >>> person and delete it manually? > >>> > >>> > >>> -- > > > ------------------------------- > To unsubscribe from the list, please send an email to > BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in > the subject and the body of the message > > > ------------------------------- > To unsubscribe from the list, please send an email to > BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in > the subject and the body of the message >

Corrected line below..... ----- Original Message ----- From: "David Bartelt" <dybartelt@comcast.net> To: <bk@rootsweb.com> Sent: Monday, January 02, 2012 10:00 AM Subject: Re: [BK] Cleaning my database? You could create a gedcom and open it with Notepad. Then copy and paste from Notepad into Excel. In Exce, create a 'number order' column with a number series 1 to whatever. This is to preserve the original order of the lines of the Gedcom. In Excel, sort on "Sensitive" and delete the approprite lines. Resort using the 'number sort' column to get back to the original order. REPLACE THIS ---> Create a Gedcom and use that to create another instance of your Brother's Keeper database. WITH THIS ---> Copy only the column data from Excel, paste into Notepad, change the file extension to .GED and you have your new cleaned gedcom. Import into another instance of Brother's Keeper. But, be warned. Exporting and importing wll change other data. You are only talking some 3000 entries and it will take some time but it wouldn't be that bad. David Bartelt ----- Original Message ----- From: "Jostein Fauske" <jostein.fauske@c2i.net> To: <bk@rootsweb.com> Sent: Monday, January 02, 2012 9:29 AM Subject: Re: [BK] Cleaning my database? On Mon, 2 Jan 2012 10:03:06 -0500, Jim Dell wrote: Jim, Thank you for the offer. The information is not sensitive, but have got this notes added by my previous program. 1 SEX M 1 BIRT 2 DATE 13 NOV 1852 2 PLAC Aamodt, Gaular, NORWAY 2 SOUR @S5@ 2 NOTE Sensitive:0 1 DEAT 2 DATE 1940 2 NOTE Sensitive:0 1 DEAT 2 DATE 1940 2 PLAC F²rde, Norway 2 NOTE Sensitive:0 1 BURI 2 DATE 1940 2 PLAC Norway 2 NOTE Sensitive:0 1 OCCU Farmer 2 NOTE Sensitive:0 Her is a short portion of the gedcom. Every line with "Sensetive:0" is not need and have to be deleted completely. >Jostein, >Post a portion of the GEDCOM file with the sensitive data (you can change >it >in the example if it's too sensitive) with the GEDCOM lines before and >after >it and let me see if I can offer some suggestions. > >Jim > >-----Original Message----- >From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf Of >Jostein Fauske >Sent: Monday, January 02, 2012 9:42 AM >To: bk@rootsweb.com >Subject: Re: [BK] Cleaning my database? > >On Sun, 1 Jan 2012 13:11:20 -0500, Jack Ray wrote: > >I have tried with a test gedcom, but I have not found a way to do a "find >and replace" that do not leave a empty line. Maybe I do not know my word >processor enough . (Open Office) I'm talking about over 3000 entries that >have to be changed so I need a automated way to do the editing. > > jostein.fauske@c2i.net>wrote: >> >>> Hi! >>> When I imported my database into BK I got some information that was >>> not wanted. My previous program had the opportunity to set an event >>> as sensitive or not. >>> This information followed the gedcom file as a note to each event. I >>> want to delete all notes that looks like this: Sensitive:0 Is there >>> any way to delete this note from the database without opening every >>> person and delete it manually? >>> >>> >>> -- ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

I am totally impressed by the knowledge and helpfulness of our group.:-) Betty On 1/2/2012 8:02 PM, Jim Ramaley wrote: > Nope, > I just checked it. You are replacing 2 CRs with 1. (and the intervening text) > Jim R > ----- Original Message ----- > From: Jim Dell > To: bk@rootsweb.com > Sent: Monday, January 02, 2012 8:57 PM > Subject: Re: [BK] Cleaning my database -- without macros > > > Jim, > I think that creates the blank lines he mentioned. > > Jim Dell > > -----Original Message----- > From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf Of > Jim Ramaley > Sent: Monday, January 02, 2012 8:46 PM > To: bk@rootsweb.com > Subject: Re: [BK] Cleaning my database -- without macros > > Jostein, > > MS-WORD actually does allow you to search for an replace carriage returns > without needing a macro. > > The key is that the carriage return can be represented by ^p (^ is the > carat symbol; shift 6 on my keyboard) > > Open your Gedcom (which is essentially a text file) in Word. > 1 Go to the find& replace dialog. > 2. In the FIND box put ^p2 NOTE Sensitive:0^p 3. In the REPLACE box put > ^p. > 4. Replace all occurrences > 5. Save the file as a txt file (use the SAVE AS dialog) > > The resulting file is what you want. Treat it as a GEDCOM. > > Jim R > Gettysburg, PA > > > > > ----- Original Message ----- > From: Jim Dell > To: bk@rootsweb.com > Sent: Monday, January 02, 2012 3:58 PM > Subject: Re: [BK] Cleaning my database? > > > Here's the basis of a quick and dirty MS Word macro that will delete a > line > beginning with > "2 NOTE Sensitive:" > > Begin: > Selection.Find.ClearFormatting > With Selection.Find > .Text = "2 NOTE Sensitive:" > .Replacement.Text = "" > .Forward = True > .Wrap = wdFindAsk > .Format = False > .MatchCase = False > .MatchWholeWord = False > .MatchWildcards = False > .MatchSoundsLike = False > .MatchAllWordForms = False > End With > Selection.Find.Execute > Selection.Extend > Selection.Extend > Selection.Extend > Selection.Delete Unit:=wdCharacter, Count:=1 > End Sub > > More work is need to make it go through the entire GEDCOM automatically. > > Jim > > -----Original Message----- > From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf > Of > Jostein Fauske > Sent: Monday, January 02, 2012 10:30 AM > To: bk@rootsweb.com > Subject: Re: [BK] Cleaning my database? > > On Mon, 2 Jan 2012 10:03:06 -0500, Jim Dell wrote: > > Jim, > Thank you for the offer. The information is not sensitive, but have got > this > notes added by my previous program. > > 1 SEX M > 1 BIRT > 2 DATE 13 NOV 1852 > 2 PLAC Aamodt, Gaular, NORWAY > 2 SOUR @S5@ > 2 NOTE Sensitive:0 > 1 DEAT > 2 DATE 1940 > 2 NOTE Sensitive:0 > 1 DEAT > 2 DATE 1940 > 2 PLAC F²rde, Norway > 2 NOTE Sensitive:0 > 1 BURI > 2 DATE 1940 > 2 PLAC Norway > 2 NOTE Sensitive:0 > 1 OCCU Farmer > 2 NOTE Sensitive:0 > > Her is a short portion of the gedcom. Every line with "Sensetive:0" is not > need and have to be deleted completely. > > >Jostein, > >Post a portion of the GEDCOM file with the sensitive data (you can > >change it in the example if it's too sensitive) with the GEDCOM lines > >before and after it and let me see if I can offer some suggestions. > > > >Jim > > > >-----Original Message----- > >From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On > >Behalf Of Jostein Fauske > >Sent: Monday, January 02, 2012 9:42 AM > >To: bk@rootsweb.com > >Subject: Re: [BK] Cleaning my database? > > > >On Sun, 1 Jan 2012 13:11:20 -0500, Jack Ray wrote: > > > >I have tried with a test gedcom, but I have not found a way to do a > >"find and replace" that do not leave a empty line. Maybe I do not know > >my word processor enough . (Open Office) I'm talking about over 3000 > >entries that have to be changed so I need a automated way to do the > editing. > > > > > >>The only way I can think to do it, is to put a gedcom into a word > >>processor and do a search for "Sensitive:0" then deletye the note. > >> > >>Jack in Ohio > >> > >>On Sun, Jan 1, 2012 at 12:37 PM, Jostein Fauske > ><jostein.fauske@c2i.net>wrote: > >> > >>> Hi! > >>> When I imported my database into BK I got some information that was > >>> not wanted. My previous program had the opportunity to set an event > >>> as sensitive or not. > >>> This information followed the gedcom file as a note to each event. I > >>> want to delete all notes that looks like this: Sensitive:0 Is there > >>> any way to delete this note from the database without opening every > >>> person and delete it manually? > >>> > >>> > >>> -- > >>> Jostein Fauske > >>> N-6977 BYGSTAD,Norway > >>> mailto:jostein.fauske@c2i.net > >>> http://www.zet.no/~josteinf/ > >>> > >>> > >>> > >>> ------------------------------- > >>> To unsubscribe from the list, please send an email to > >>> BK-request@rootsweb.com with the word 'unsubscribe' without the > >>> quotes in the subject and the body of the message > >>> > >> > >>------------------------------- > >>To unsubscribe from the list, please send an email to > >>BK-request@rootsweb.com with the word 'unsubscribe' without the quotes > >>in the subject and the body of the message > > > > > >------------------------------- > >To unsubscribe from the list, please send an email to > >BK-request@rootsweb.com with the word 'unsubscribe' without the quotes > >in the subject and the body of the message > > > > > >------------------------------- > >To unsubscribe from the list, please send an email to > >BK-request@rootsweb.com with the word 'unsubscribe' without the quotes > >in the subject and the body of the message > > -- > Jostein Fauske > N-6977 BYGSTAD,Norway > mailto:jostein.fauske@c2i.net > http://www.zet.no/~josteinf/ > > > > ------------------------------- > To unsubscribe from the list, please send an email to > BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in > the subject and the body of the message > > > > ------------------------------- > To unsubscribe from the list, please send an email to > BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in > the subject and the body of the message > > ------------------------------- > To unsubscribe from the list, please send an email to > BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in > the subject and the body of the message > > > > ------------------------------- > To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message > > ------------------------------- > To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message >

Nope, I just checked it. You are replacing 2 CRs with 1. (and the intervening text) Jim R ----- Original Message ----- From: Jim Dell To: bk@rootsweb.com Sent: Monday, January 02, 2012 8:57 PM Subject: Re: [BK] Cleaning my database -- without macros Jim, I think that creates the blank lines he mentioned. Jim Dell -----Original Message----- From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf Of Jim Ramaley Sent: Monday, January 02, 2012 8:46 PM To: bk@rootsweb.com Subject: Re: [BK] Cleaning my database -- without macros Jostein, MS-WORD actually does allow you to search for an replace carriage returns without needing a macro. The key is that the carriage return can be represented by ^p (^ is the carat symbol; shift 6 on my keyboard) Open your Gedcom (which is essentially a text file) in Word. 1 Go to the find & replace dialog. 2. In the FIND box put ^p2 NOTE Sensitive:0^p 3. In the REPLACE box put ^p. 4. Replace all occurrences 5. Save the file as a txt file (use the SAVE AS dialog) The resulting file is what you want. Treat it as a GEDCOM. Jim R Gettysburg, PA ----- Original Message ----- From: Jim Dell To: bk@rootsweb.com Sent: Monday, January 02, 2012 3:58 PM Subject: Re: [BK] Cleaning my database? Here's the basis of a quick and dirty MS Word macro that will delete a line beginning with "2 NOTE Sensitive:" Begin: Selection.Find.ClearFormatting With Selection.Find .Text = "2 NOTE Sensitive:" .Replacement.Text = "" .Forward = True .Wrap = wdFindAsk .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Selection.Extend Selection.Extend Selection.Extend Selection.Delete Unit:=wdCharacter, Count:=1 End Sub More work is need to make it go through the entire GEDCOM automatically. Jim -----Original Message----- From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf Of Jostein Fauske Sent: Monday, January 02, 2012 10:30 AM To: bk@rootsweb.com Subject: Re: [BK] Cleaning my database? On Mon, 2 Jan 2012 10:03:06 -0500, Jim Dell wrote: Jim, Thank you for the offer. The information is not sensitive, but have got this notes added by my previous program. 1 SEX M 1 BIRT 2 DATE 13 NOV 1852 2 PLAC Aamodt, Gaular, NORWAY 2 SOUR @S5@ 2 NOTE Sensitive:0 1 DEAT 2 DATE 1940 2 NOTE Sensitive:0 1 DEAT 2 DATE 1940 2 PLAC F²rde, Norway 2 NOTE Sensitive:0 1 BURI 2 DATE 1940 2 PLAC Norway 2 NOTE Sensitive:0 1 OCCU Farmer 2 NOTE Sensitive:0 Her is a short portion of the gedcom. Every line with "Sensetive:0" is not need and have to be deleted completely. >Jostein, >Post a portion of the GEDCOM file with the sensitive data (you can >change it in the example if it's too sensitive) with the GEDCOM lines >before and after it and let me see if I can offer some suggestions. > >Jim > >-----Original Message----- >From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On >Behalf Of Jostein Fauske >Sent: Monday, January 02, 2012 9:42 AM >To: bk@rootsweb.com >Subject: Re: [BK] Cleaning my database? > >On Sun, 1 Jan 2012 13:11:20 -0500, Jack Ray wrote: > >I have tried with a test gedcom, but I have not found a way to do a >"find and replace" that do not leave a empty line. Maybe I do not know >my word processor enough . (Open Office) I'm talking about over 3000 >entries that have to be changed so I need a automated way to do the editing. > > >>The only way I can think to do it, is to put a gedcom into a word >>processor and do a search for "Sensitive:0" then deletye the note. >> >>Jack in Ohio >> >>On Sun, Jan 1, 2012 at 12:37 PM, Jostein Fauske ><jostein.fauske@c2i.net>wrote: >> >>> Hi! >>> When I imported my database into BK I got some information that was >>> not wanted. My previous program had the opportunity to set an event >>> as sensitive or not. >>> This information followed the gedcom file as a note to each event. I >>> want to delete all notes that looks like this: Sensitive:0 Is there >>> any way to delete this note from the database without opening every >>> person and delete it manually? >>> >>> >>> -- >>> Jostein Fauske >>> N-6977 BYGSTAD,Norway >>> mailto:jostein.fauske@c2i.net >>> http://www.zet.no/~josteinf/ >>> >>> >>> >>> ------------------------------- >>> To unsubscribe from the list, please send an email to >>> BK-request@rootsweb.com with the word 'unsubscribe' without the >>> quotes in the subject and the body of the message >>> >> >>------------------------------- >>To unsubscribe from the list, please send an email to >>BK-request@rootsweb.com with the word 'unsubscribe' without the quotes >>in the subject and the body of the message > > >------------------------------- >To unsubscribe from the list, please send an email to >BK-request@rootsweb.com with the word 'unsubscribe' without the quotes >in the subject and the body of the message > > >------------------------------- >To unsubscribe from the list, please send an email to >BK-request@rootsweb.com with the word 'unsubscribe' without the quotes >in the subject and the body of the message -- Jostein Fauske N-6977 BYGSTAD,Norway mailto:jostein.fauske@c2i.net http://www.zet.no/~josteinf/ ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Jim, I think that creates the blank lines he mentioned. Jim Dell -----Original Message----- From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf Of Jim Ramaley Sent: Monday, January 02, 2012 8:46 PM To: bk@rootsweb.com Subject: Re: [BK] Cleaning my database -- without macros Jostein, MS-WORD actually does allow you to search for an replace carriage returns without needing a macro. The key is that the carriage return can be represented by ^p (^ is the carat symbol; shift 6 on my keyboard) Open your Gedcom (which is essentially a text file) in Word. 1 Go to the find & replace dialog. 2. In the FIND box put ^p2 NOTE Sensitive:0^p 3. In the REPLACE box put ^p. 4. Replace all occurrences 5. Save the file as a txt file (use the SAVE AS dialog) The resulting file is what you want. Treat it as a GEDCOM. Jim R Gettysburg, PA ----- Original Message ----- From: Jim Dell To: bk@rootsweb.com Sent: Monday, January 02, 2012 3:58 PM Subject: Re: [BK] Cleaning my database? Here's the basis of a quick and dirty MS Word macro that will delete a line beginning with "2 NOTE Sensitive:" Begin: Selection.Find.ClearFormatting With Selection.Find .Text = "2 NOTE Sensitive:" .Replacement.Text = "" .Forward = True .Wrap = wdFindAsk .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Selection.Extend Selection.Extend Selection.Extend Selection.Delete Unit:=wdCharacter, Count:=1 End Sub More work is need to make it go through the entire GEDCOM automatically. Jim -----Original Message----- From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf Of Jostein Fauske Sent: Monday, January 02, 2012 10:30 AM To: bk@rootsweb.com Subject: Re: [BK] Cleaning my database? On Mon, 2 Jan 2012 10:03:06 -0500, Jim Dell wrote: Jim, Thank you for the offer. The information is not sensitive, but have got this notes added by my previous program. 1 SEX M 1 BIRT 2 DATE 13 NOV 1852 2 PLAC Aamodt, Gaular, NORWAY 2 SOUR @S5@ 2 NOTE Sensitive:0 1 DEAT 2 DATE 1940 2 NOTE Sensitive:0 1 DEAT 2 DATE 1940 2 PLAC F²rde, Norway 2 NOTE Sensitive:0 1 BURI 2 DATE 1940 2 PLAC Norway 2 NOTE Sensitive:0 1 OCCU Farmer 2 NOTE Sensitive:0 Her is a short portion of the gedcom. Every line with "Sensetive:0" is not need and have to be deleted completely. >Jostein, >Post a portion of the GEDCOM file with the sensitive data (you can >change it in the example if it's too sensitive) with the GEDCOM lines >before and after it and let me see if I can offer some suggestions. > >Jim > >-----Original Message----- >From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On >Behalf Of Jostein Fauske >Sent: Monday, January 02, 2012 9:42 AM >To: bk@rootsweb.com >Subject: Re: [BK] Cleaning my database? > >On Sun, 1 Jan 2012 13:11:20 -0500, Jack Ray wrote: > >I have tried with a test gedcom, but I have not found a way to do a >"find and replace" that do not leave a empty line. Maybe I do not know >my word processor enough . (Open Office) I'm talking about over 3000 >entries that have to be changed so I need a automated way to do the editing. > > >>The only way I can think to do it, is to put a gedcom into a word >>processor and do a search for "Sensitive:0" then deletye the note. >> >>Jack in Ohio >> >>On Sun, Jan 1, 2012 at 12:37 PM, Jostein Fauske ><jostein.fauske@c2i.net>wrote: >> >>> Hi! >>> When I imported my database into BK I got some information that was >>> not wanted. My previous program had the opportunity to set an event >>> as sensitive or not. >>> This information followed the gedcom file as a note to each event. I >>> want to delete all notes that looks like this: Sensitive:0 Is there >>> any way to delete this note from the database without opening every >>> person and delete it manually? >>> >>> >>> -- >>> Jostein Fauske >>> N-6977 BYGSTAD,Norway >>> mailto:jostein.fauske@c2i.net >>> http://www.zet.no/~josteinf/ >>> >>> >>> >>> ------------------------------- >>> To unsubscribe from the list, please send an email to >>> BK-request@rootsweb.com with the word 'unsubscribe' without the >>> quotes in the subject and the body of the message >>> >> >>------------------------------- >>To unsubscribe from the list, please send an email to >>BK-request@rootsweb.com with the word 'unsubscribe' without the quotes >>in the subject and the body of the message > > >------------------------------- >To unsubscribe from the list, please send an email to >BK-request@rootsweb.com with the word 'unsubscribe' without the quotes >in the subject and the body of the message > > >------------------------------- >To unsubscribe from the list, please send an email to >BK-request@rootsweb.com with the word 'unsubscribe' without the quotes >in the subject and the body of the message -- Jostein Fauske N-6977 BYGSTAD,Norway mailto:jostein.fauske@c2i.net http://www.zet.no/~josteinf/ ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Jostein, MS-WORD actually does allow you to search for an replace carriage returns without needing a macro. The key is that the carriage return can be represented by ^p (^ is the carat symbol; shift 6 on my keyboard) Open your Gedcom (which is essentially a text file) in Word. 1 Go to the find & replace dialog. 2. In the FIND box put ^p2 NOTE Sensitive:0^p 3. In the REPLACE box put ^p. 4. Replace all occurrences 5. Save the file as a txt file (use the SAVE AS dialog) The resulting file is what you want. Treat it as a GEDCOM. Jim R Gettysburg, PA ----- Original Message ----- From: Jim Dell To: bk@rootsweb.com Sent: Monday, January 02, 2012 3:58 PM Subject: Re: [BK] Cleaning my database? Here's the basis of a quick and dirty MS Word macro that will delete a line beginning with "2 NOTE Sensitive:" Begin: Selection.Find.ClearFormatting With Selection.Find .Text = "2 NOTE Sensitive:" .Replacement.Text = "" .Forward = True .Wrap = wdFindAsk .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Selection.Extend Selection.Extend Selection.Extend Selection.Delete Unit:=wdCharacter, Count:=1 End Sub More work is need to make it go through the entire GEDCOM automatically. Jim -----Original Message----- From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On Behalf Of Jostein Fauske Sent: Monday, January 02, 2012 10:30 AM To: bk@rootsweb.com Subject: Re: [BK] Cleaning my database? On Mon, 2 Jan 2012 10:03:06 -0500, Jim Dell wrote: Jim, Thank you for the offer. The information is not sensitive, but have got this notes added by my previous program. 1 SEX M 1 BIRT 2 DATE 13 NOV 1852 2 PLAC Aamodt, Gaular, NORWAY 2 SOUR @S5@ 2 NOTE Sensitive:0 1 DEAT 2 DATE 1940 2 NOTE Sensitive:0 1 DEAT 2 DATE 1940 2 PLAC F²rde, Norway 2 NOTE Sensitive:0 1 BURI 2 DATE 1940 2 PLAC Norway 2 NOTE Sensitive:0 1 OCCU Farmer 2 NOTE Sensitive:0 Her is a short portion of the gedcom. Every line with "Sensetive:0" is not need and have to be deleted completely. >Jostein, >Post a portion of the GEDCOM file with the sensitive data (you can >change it in the example if it's too sensitive) with the GEDCOM lines >before and after it and let me see if I can offer some suggestions. > >Jim > >-----Original Message----- >From: bk-bounces@rootsweb.com [mailto:bk-bounces@rootsweb.com] On >Behalf Of Jostein Fauske >Sent: Monday, January 02, 2012 9:42 AM >To: bk@rootsweb.com >Subject: Re: [BK] Cleaning my database? > >On Sun, 1 Jan 2012 13:11:20 -0500, Jack Ray wrote: > >I have tried with a test gedcom, but I have not found a way to do a >"find and replace" that do not leave a empty line. Maybe I do not know >my word processor enough . (Open Office) I'm talking about over 3000 >entries that have to be changed so I need a automated way to do the editing. > > >>The only way I can think to do it, is to put a gedcom into a word >>processor and do a search for "Sensitive:0" then deletye the note. >> >>Jack in Ohio >> >>On Sun, Jan 1, 2012 at 12:37 PM, Jostein Fauske ><jostein.fauske@c2i.net>wrote: >> >>> Hi! >>> When I imported my database into BK I got some information that was >>> not wanted. My previous program had the opportunity to set an event >>> as sensitive or not. >>> This information followed the gedcom file as a note to each event. I >>> want to delete all notes that looks like this: Sensitive:0 Is there >>> any way to delete this note from the database without opening every >>> person and delete it manually? >>> >>> >>> -- >>> Jostein Fauske >>> N-6977 BYGSTAD,Norway >>> mailto:jostein.fauske@c2i.net >>> http://www.zet.no/~josteinf/ >>> >>> >>> >>> ------------------------------- >>> To unsubscribe from the list, please send an email to >>> BK-request@rootsweb.com with the word 'unsubscribe' without the >>> quotes in the subject and the body of the message >>> >> >>------------------------------- >>To unsubscribe from the list, please send an email to >>BK-request@rootsweb.com with the word 'unsubscribe' without the quotes >>in the subject and the body of the message > > >------------------------------- >To unsubscribe from the list, please send an email to >BK-request@rootsweb.com with the word 'unsubscribe' without the quotes >in the subject and the body of the message > > >------------------------------- >To unsubscribe from the list, please send an email to >BK-request@rootsweb.com with the word 'unsubscribe' without the quotes >in the subject and the body of the message -- Jostein Fauske N-6977 BYGSTAD,Norway mailto:jostein.fauske@c2i.net http://www.zet.no/~josteinf/ ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------- To unsubscribe from the list, please send an email to BK-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message