To Rich Beitler When you make a TXT file, it is text only and when you view it with your word processor, set the text font to Courier New. You must view it with a font that is fixed spacing in order for the columns to line up. If you want to import it into a spreadsheet or database program, then before you make the text file, add field 91 also. Then pick FIle, Create TXT file and it will make a comma separated value file, so you can name it .CSV in stead of TXT In the BK manual, see page 51-54 about the custom reports. John Steed ----- Original Message ----- From: "Rick Beitler" <rabone@gmail.com> To: "Brothers Keeper List" <BK-L@rootsweb.com> Sent: Sunday, April 29, 2012 2:39 PM Subject: [BK] Reports in a text editor > Question on using BK generated reports in a text editor. I have been > reading for some time about the option of creating a BK report as a txt > file, then manipulating it using a text editor. I tried this on a search > report I did on finding everyone in my database I have listed as being > buried in a certain cemetery. When I opened this txt file, the spacing was > now all wrong, as it had been done by hard spaces inside BK. To use this > data, it would take a lot of time to remove the spaces and replace with > tabs. Opening it inside a spreadsheet application was even worse, as it > read each row entry as a single cell entry! > > Suggestions on how to proceed from those of you who have in the past > worked with BK generated reports inside a text editor. > > Thanks. > > > Rick Beitler > rabone@gmail.com > http://chertyrock.blogspot.com > > Preach the Gospel at all times and when necessary use words. ~Saint > Francis of Assisi > > Remember - Use the Archives at > http://archiver.rootsweb.ancestry.com/cgi-bin/search > ------------------------------- > 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 >
Thanks to all who replied, and especially thanks to John, reminding me that I should read the manual as it might have some answers! I usually do, just didn't take the time this time. BK is great software. Love it. Rick Beitler rabone@gmail.com http://chertyrock.blogspot.com Golf is a good walk spoiled. ~Mark Twain On Apr 30, 2012, at 10:21 AM, John Steed wrote: > To Rich Beitler > > When you make a TXT file, it is text only and when you view it with your word processor, set the text font to Courier New. > > You must view it with a font that is fixed spacing in order for the columns to line up. > > If you want to import it into a spreadsheet or database program, then before you make the text file, add field 91 also. Then pick FIle, Create TXT file and it will make a comma separated value file, so you can name it .CSV in stead of TXT > > In the BK manual, see page 51-54 about the custom reports. > > John Steed > > > ----- Original Message ----- From: "Rick Beitler" <rabone@gmail.com> > To: "Brothers Keeper List" <BK-L@rootsweb.com> > Sent: Sunday, April 29, 2012 2:39 PM > Subject: [BK] Reports in a text editor > > >> Question on using BK generated reports in a text editor. I have been reading for some time about the option of creating a BK report as a txt file, then manipulating it using a text editor. I tried this on a search report I did on finding everyone in my database I have listed as being buried in a certain cemetery. When I opened this txt file, the spacing was now all wrong, as it had been done by hard spaces inside BK. To use this data, it would take a lot of time to remove the spaces and replace with tabs. Opening it inside a spreadsheet application was even worse, as it read each row entry as a single cell entry! >> >> Suggestions on how to proceed from those of you who have in the past worked with BK generated reports inside a text editor. >> >> Thanks. >> >> >> Rick Beitler >> rabone@gmail.com >> http://chertyrock.blogspot.com >> >> Preach the Gospel at all times and when necessary use words. ~Saint Francis of Assisi >> >> Remember - Use the Archives at http://archiver.rootsweb.ancestry.com/cgi-bin/search >> ------------------------------- >> 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 >