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