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/

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. Create a Gedcom and use that to create another instance of your Brother's Keeper database. 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? >>> >>> >>> --

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

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