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 >