Re: Delimiting columns in Notepad
- From: "Dave Carlson" <dgcarlson@xxxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Tue, 3 Feb 2009 15:17:44 -0800
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
Other related posts:
