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

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

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