Hi David and all: Good news. I could not separate data your suggested way SoI opened the PFirelog.Log file, copied and pasted to clipboard, opened Excel and pasted data. All data from firewall report is in first column A, fields separated by a space. So to experiment Alt+d arrow down to text to columns and enter. Wizzard appears, I checkd delimited, next, checked space as delimiter, next After looking at report only 1 line changed. So I typed control+g and enter type a6:a499 to select cells and enter repeated above process and all data from a6:A499 are now in separate columns. I need to repeat many times to select cels. I think Excel will only allow 499 or 500 selected cells at once. Anyway thanks to all on list who gave me direction. Ann ----- Original Message ----- From: "Lennie Rinaldi" <merlin739@xxxxxxxxx> To: <blind-windows@xxxxxxxxxxxxx> Sent: Wednesday, February 04, 2009 9:29 AM Subject: [blind-windows] Re: delimiting Notepad to Excel > Hi Ann, > > You might want to try going to Alt+D and arrow down to imported external > data. > > Right arrow to import data and hit enter. > > Follow the information needed. After you enter the file name, enter > on the open button to bring up the wizard. I think that you should be > able to follow the wizard. You should be able to set the delimiter to > space to separate the data into columns. > > I wish that I could be of more help. > > Lennie > > At 03:33 PM 2/3/2009, you wrote: >>Hi Everyone, >>Windows Firewall creates a PFirewall.Log file which can be opened by >>Notepad. This file tracks what is going on within my desktop. I would >>like >>to have each column go into a separate column in another application such >>as >>word or excel so I can sort, summarize and follow data on a specific >>column. This report has date, time, action, protocol, SRC-IP, SRC-Port, >>DST-Port. >>Each column is separated by a space. Does anyone know how I can use Jaws >>to >>import this text file so that each column on text report can go into a >>separate column in Excel? >>I think this term is called delimiting. Presently, when I copy the entire >>report to clipboard and paste into Excel all columns go into first column. >>Thanks, >>Ann >> >> >>========== >>List Owner: >>Everett Zufelt >>http://zufelt.ca >> >>View the list's information at >>//www.freelists.org/list/blind-windows > > > ========== > List Owner: > Everett Zufelt > http://zufelt.ca > > View the list's information at > //www.freelists.org/list/blind-windows > -------------------------------------------------------------------------------- Checked by AVG - www.avg.com Version: 8.0.233 / Virus Database: 270.10.17/1933 - Release Date: 02/03/09 ----- Original Message ----- From: Dave Carlson To: jfw@xxxxxxxxxxxxx Sent: Tuesday, February 03, 2009 6:17 PM Subject: Re: Delimiting columns in Notepad Ann, I use MS-Word as the intermediary. Paste your text to an open MS-Word document. Make sure all the text is highlighted. In Word 2003 Alt+A, v, x (This is tables, convert, Text-to-table). In Word 2007 it's the same keystrokes, but you can use the ribbon if you're comfortable with it. Select auto-format and select the space character as the column delimiter. Make sure you tab around in the dialog and check the number of columns that Word is anticipating. Change this if it's not what you expected. Press OK. You'll get a table Select the entire table and copy. Paste into an open Excel sheet. The first time you do this, it's likely you'll find that things don't work as expected,so prepare to play around a lot with the original text file. It works better if the columns are delimited with a tab character, as spaces can be in the body of a cell. Dave ----- Original Message ----- From: Ann Medlar To: jfw@xxxxxxxxxxxxx Sent: February 03, 2009 11:56 AM Subject: Delimiting columns in Notepad Hi Everyone, Windows Firewall creates a PFirewall.Log file which can be opened by Notepad. This file tracks what is going on within my desktop. I would like to have each column go into a separate column in another application such as word or excel so I can sort, summarize and follow data on a specific column. This report has date, time, action, protocol, SRC-IP, SRC-Port, DST-Port. Each column is separated by a space. Does anyone know how I can use Jaws to import this text file so that each column on text report can go into a separate column in Excel? I think this term is called delimiting. Presently, when I copy the entire report to clipboard and paste into Excel all columns go into first column. Thanks, Ann ---------------------------------------------------------------------------- Checked by AVG - www.avg.com Version: 8.0.233 / Virus Database: 270.10.17/1931 - Release Date: 01/31/09 20:03:00 ------------------------------------------------------------------------------ Checked by AVG - www.avg.com Version: 8.0.233 / Virus Database: 270.10.17/1933 - Release Date: 02/03/09 17:48:00
Checked by AVG - www.avg.com Version: 8.0.233 / Virus Database: 270.10.17/1933 - Release Date: 02/03/09 17:48:00