Re: Delimiting columns in Notepad
- From: "Ann Medlar" <amedlar1@xxxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 5 Feb 2009 14:23:58 -0500
Tom,
Thank you very much. It worked.
Ann
----- Original Message -----
From: Bissett, Tom
To: jfw@xxxxxxxxxxxxx
Sent: Thursday, February 05, 2009 9:18 AM
Subject: RE: Delimiting columns in Notepad
Hi Ann, I experemented with the log file. I had to delete the header part
and the "#fileds" from the header row and then was able to bring the file
correctly into excel using the file open selecting text as file type and
following the wizard. It takes a lot less work than trying to reformat the
file.
Tom Bissett
BMO Financial Group
Technology and Operations
Integrated Client Solutions
Tel: (416) 549-6514
E-Mail tom.bissett@xxxxxxx
------------------------------------------------------------------------------
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On Behalf Of
Ann Medlar
Sent: Wednesday, February 04, 2009 2:29 PM
To: jfw@xxxxxxxxxxxxx
Subject: Re: Delimiting columns in Notepad
Is there a hot key to get to delimited column?See below for comments.
I cannot seem to get to delimited field under auto format
----- 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.
I am using MS word 2003
Paste your text to an open MS-Word document. done
Make sure all the text is highlighted done.
In Word 2003 Alt+A, v, x (This is tables, convert, Text-to-table). done
In Word 2007 it's the same keystrokes, but you can use the ribbon if you're
comfortable with it.
I get tables styles in use and see no delimited field
went to all table, user defined tables and did not get delimited field.
There is a check box for rows and columns
Select auto-format and select the space character as the column delimiter.
Again no delimited field Only check boxes
I am Using Windows 6.0
category states that table styles in use so went into user defined and
tabbed around no luck.
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.
I changed to15
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.18/1936 - Release Date: 02/04/09
16:35:00
Checked by AVG - www.avg.com
Version: 8.0.233 / Virus Database: 270.10.18/1936 - Release Date: 02/04/09
16:35:00
Other related posts:
