Umm yeah that would be cool, but if you have Visual Basic that maybe a good
route. It would be easy to parse the text file and then write it out to a
csv file. A csv file will open in Excel and look fine. Then compile exe
and schedule to run at any time. As a matter of fact you could probably do
it just the same with VBscrit if you don't have visual basic.
Good Luck,
John
-----Original Message-----
From: Mellott, Bill [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 10:06 AM
To: Exchange Discussions
Subject: RE: Very OT - txt handling
You could get the MS UNix service 3.0 very inexpensively..
It's cool..work pretty well for the tools Ive used so far..
cheap for what you get and it's power..
has may unix thing ported to MS/win32
bill
-----Original Message-----
From: King, Arron S. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 8:37 AM
To: Exchange Discussions
Subject: RE: Very OT - txt handling
Kim,
There are several things that might be of help.
A combination of Unix tools (ported to Win32 of course) grep & wc (grep can
search for text/regular expression and wc can count lines, characters etc.
This will find out the stats you want; but won't automatically update the
files. You can create text files; but would need to import them. Search
google for the win32 ports of these utilites. I don't have an exact URL.
Perl is an excellent language for parsing text. You should be able to use
it to count up the statistics you are looking for, and then create/update a
document like it sounds like you want to do. http://www.activestate.com
HTH
Arron
=======================================
Arron S. King
Network & Systems Administrator
Ohio Dominican University
[EMAIL PROTECTED]
v: 614.251.4515
f: 614.252.2650
-----Original Message-----
From: Kim Schotanus [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 7:13 AM
To: Exchange Discussions
Subject: Very OT - txt handling
Hi there,
I came across your address on the net, and I would like to ask you a
quick programming question. Could you point me out to a sort of code
that can count the number of characters and lines in a txt file and
transfer that to exell or access?
I have the following example (txt)
45 14:53:52 ENTRANCE ARTS (2) ACCESS GRANTED KIM SCHOTANUS (16788937)
46 15:14:52 EXIT ARTS GRANTED
47 16:00:48 ENTRANCE ARTS (2) ACCESS GRANTED PROCOPIO ALB (07723137)
48 16:52:24 EXIT ARTS (3) ACCESS GRANTED BECKERS PAUL (04906723)
...
In this example the first line is the line number, that is reset to 00
after 99, then there is the time, the action performed -ENTRANCE ARTS
(2) ACCESS GRANTED- and the name and permission code.
Line 46 is a special command, this is when someone overrides the system
(which happens quite often)
after each 20 lines there is a blank line and then a line with the date
The idea is to find/create a little code that pushes the data in this
txt file to exell on a daily basis.
Do you know of any code that could do this?
_________________________________________________________________
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin: [EMAIL PROTECTED]
_________________________________________________________________
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin: [EMAIL PROTECTED]
_________________________________________________________________
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin: [EMAIL PROTECTED]
_________________________________________________________________
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin: [EMAIL PROTECTED]
