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 >