The Multifunctioning DBA

Mar 18 2009   7:58PM GMT

Powershell VS VBScript

Colin Smith Colin Smith Profile: Colin Smith

My wife works for a large company as an accountant for a company here in Phoenix and she called me one day asking if I could put a script together that would do some file manipulation and combine multiple files into one. I said no problem. You tell me what you need and I can do it in Powershell. She told me everything that she wanted it to do and provided me with some sample input files to work with. I would put the scripts on here but they are so unique to what she needs that I do not think they would help anyone else. Anyway, I got it done in Powershell and I called her and emailed her the file and said let me know. She informed me that she did not have powershell on her machine at work and that it would not work. I later went to her office and found that they are using Windows 2000 so Powershell is not even supported. I thought well I guess I could do it in VBScript.

I went back to my computer and started hammering out the code. I finished the script and found that I had over 200 lines of code. I went back to my Powershell script and found that I had just over 30 lines. To me Powershell wins hands down just because of that. With the ease of the pipe I am able to write much less code and accomplish so much more.

Let me know your thoughts on Powershell VS VBScript by leaving a comment or heading to and clicking on the Submit a Question link on the right.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: