RE: Delimiting columns in Notepad
- From: "Griffiths, Steve" <Steve.Griffiths@xxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Wed, 4 Feb 2009 03:58:30 -0000
Ann,
If you try opening the file straight into Excel you should get a text
import wizard that will allow you to do this. You'll have to change the
Show What combo in the Open dialogue to "all files" so that you get the
log file in the listview first.
When I did this I found the first three rows and row 5 were redundant so
I deleted them. Row 4 (now row 1) contained the headings to the columns
but the first cell wasn't needed so I deleted that and shifted cells
left to line up the row headings correctly.
Steve
-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf Of Ann Medlar
Sent: 03 February 2009 19:56
To: jfw@xxxxxxxxxxxxx
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
Click here
<https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
2L6eAMFpnPTZwDrh5hlBWn1yZ+IIH7BM4C7ZM0Vr2cPI!w==> to report this email
as spam.
--
DISCLAIMER:
NOTICE: The information contained in this email and any attachments is
confidential and may be privileged. If you are not the intended
recipient you should not use, disclose, distribute or copy any of the
content of it or of any attachment; you are requested to notify the
sender immediately of your receipt of the email and then to delete it
and any attachments from your system.
RNIB endeavours to ensure that emails and any attachments generated by
its staff are free from viruses or other contaminants. However, it
cannot accept any responsibility for any such which are transmitted.
We therefore recommend you scan all attachments.
Please note that the statements and views expressed in this email and
any attachments are those of the author and do not necessarily represent
those of RNIB.
RNIB Registered Charity Number: 226227
Website: http://www.rnib.org.uk
This message has been scanned for viruses by Websense Hosted Security -
http://www.websense.com/content/HostedEmailSecurity.aspx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
Alternative archives located at:
http://n2.nabble.com/JAWS-for-Windows-f2145279.html
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
