jjcarter1988
New Member
- Joined
- Nov 24, 2013
- Messages
- 28
So... I have done some research on the topic and not found a particular answer that helps out.
My current situation is that I have a .log file which I run a perl script on to parse the file for specific parameters needed. To do this I simply am in a Terminal window issuing the perl script on the log file. I then turn the parsed information into a csv file (for read out and importing purposes). The command I use in Terminal basically is "read_log ex.log > ex.csv". Obviously this is calling the perl script read_log.pl.
With my current macro I use GetOpenFileName to choose the csv file I created and then import it to the sheet.
What I am wondering is, can I simply use GetOpenFileName to choose the unparsed log file, and the use VB to run the perl script on the log file to parse it, turn it into a csv, and then import it?
I know this seems petty since is just one step I am eliminating, however I am curious if VB can do this.
Thanks in Advance!
My current situation is that I have a .log file which I run a perl script on to parse the file for specific parameters needed. To do this I simply am in a Terminal window issuing the perl script on the log file. I then turn the parsed information into a csv file (for read out and importing purposes). The command I use in Terminal basically is "read_log ex.log > ex.csv". Obviously this is calling the perl script read_log.pl.
With my current macro I use GetOpenFileName to choose the csv file I created and then import it to the sheet.
What I am wondering is, can I simply use GetOpenFileName to choose the unparsed log file, and the use VB to run the perl script on the log file to parse it, turn it into a csv, and then import it?
I know this seems petty since is just one step I am eliminating, however I am curious if VB can do this.
Thanks in Advance!
