Scripting Central

Perspectives
- The Good, Better, and Best Ways to Find Constants and Their Values
in WSH Scripts

Important News
- HTML Formatting and Easier Access to Online Content Coming to
Scripting Central

Scripting Toolkit
- T-SQL UDF Strips Out Non-Alphanumeric Characters

Info to Go

/* ==================================== */

:: **** Perspectives ****
by Karen Bemowski, kbemowski@windowsitpro.com

The Good, Better, and Best Ways to Find Constants and Their Values
in WSH Scripts
The COM technology behind objects such as Windows Script Host's (WSH's)
WshShell object and the Microsoft Scripting Runtime Library's
FileSystemObject object is what makes WSH scripts powerful. However, the way
this technology works causes scripters grief in one area: Scripts don't get
access to the constants embedded in objects. Learn why scripts don't get
access and find out the good, better, and best ways to workaround this
limitation in the article "How to Find Constants and Their Values" by
Alex K. Angelopoulos.
To read Alex's article, go to http://pentonmedia.whatcounts.com/t?ctl=7039F:6B7D3383C3CE944407DB77CE4DB758AD .
I've opened up this article for public viewing through January 3. If you
enjoy reading this article, you can get more of this type of content by
subscribing to Scripting Pro VIP
( http://pentonmedia.whatcounts.com/t?ctl=703A6:6B7D3383C3CE944407DB77CE4DB758AD ).

:: **** Important News ****

HTML Formatting and Easier Access to Online Content Coming to
Scripting Central
We're excited to announce that beginning Friday, January 4, 2008,
Scripting Central will be available in HTML. To see a preview of what
our HTML newsletters look like, go to
http://pentonmedia.whatcounts.com/t?ctl=703AA:6B7D3383C3CE944407DB77CE4DB758AD .
You'll automatically start receiving Scripting Central in HTML. However,
you have the option of receiving a text version if that's what you prefer.
You can opt to receive a text version by going to
http://pentonmedia.whatcounts.com/t?ctl=703AB:6B7D3383C3CE944407DB77CE4DB758AD starting Monday, December 10. Note that
you'll be required to log on to note your email newsletter preference. (If
you're not currently a Web site registrant, you'll need to register.)
Scripting Central will be mailed from a new email address, so be sure to
add

Scripting_Central@email.windowsitpro.com

to your list of allowed senders and contacts so you'll continue receiving
this newsletter. The IP address range from which it will originate is
204.92.180.[85-86], which you can typically get whitelisted by your email
service provider or spam filter.
In addition, based on popular demand of our readers, you'll now be able to
read the author's commentary online without needing to register and log on to
our Web site. You can find a variety of other content at windowsitpro.com as
well. We hope you'll be as excited as we are about the new look for and
easier online access to Scripting Central.

:: **** Scripting Toolkit ****

T-SQL UDF Strips Out Non-Alphanumeric Characters
SQL Server offers a variety of string functions, but it doesn't have a
function that strips out non-alphanumeric characters, such as a hyphen (-),
percent sign (%), or semicolon (;). To fill this gap, Louis Nguyen, a
database administrator for Centex Homes, created a user-defined function
(UDF) named Strim.
Strim works on SQL Server 2005, SQL Server 2000, and SQL Server 7.0. To
find out how this T-SQL function works and download its code, go to the SQL
Server Magazine article "Strim Strips Out Non-Alphanumeric Characters" at
http://pentonmedia.whatcounts.com/t?ctl=703A4:6B7D3383C3CE944407DB77CE4DB758AD .
This article is open for public viewing.

:: **** Info to Go ****

Attend the "Power Up! With Virtualization" online conference on Dec. 12. Learn
how to take virtualization to another level. Whether you're just getting
started or need to more effectively optimize your current virtual environment,
discover how you can take the promise of virtualization and turn it into
reality. Join Windows IT Pro and key independent virtualization experts for
powerful tips such as how to create a virtual machine (VM), ways to properly
size VMs for server consolidation, and system factors that affect performance.
http://pentonmedia.whatcounts.com/t?ctl=703A2:6B7D3383C3CE944407DB77CE4DB758AD

Are you understaffed and constantly putting out fires? Learn how to more
efficiently manage midsized-business systems in this Web seminar on Dec. 11
(12:00 PM EST). Unlike enterprise-class IT organizations, IT departments in
mid-market companies rarely have a large IT staff or the ability to dedicate a
lot of resources to proactive IT management. These challenges have been poorly
addressed by third-party system management offerings. Attend this Web seminar
to learn how to deal with mid-market IT management challenges.
http://pentonmedia.whatcounts.com/t?ctl=703A0:6B7D3383C3CE944407DB77CE4DB758AD

Today's hackers are after your enterprise data, and the tools and services
they employ to get at it are provided by a sophisticated, fast-growing
criminal support industry. Even more surprising--and worrying--is how
ineffective today's standard enterprise security practices are at stopping
these sophisticated attacks. Attend this Web seminar to learn how high-tech
criminals compromise your computers and profit from your data by putting
confidential info up for sale.
http://pentonmedia.whatcounts.com/t?ctl=703A1:6B7D3383C3CE944407DB77CE4DB758AD

Unified Communications: What Is It? Why Should You Care? And How to Get There
Unified communications (UC) helps you manage voice, email, fax, and phone
communications from one set of management controls. But from a practical
standpoint, how do you get started? This white paper breaks the move to UC
down into a manageable 3-phase process that starts with unified messaging
(UM). Learn practical tips and a phased approach for getting started with UM
as the first step toward a UC environment in the future.
http://pentonmedia.whatcounts.com/t?ctl=703A3:6B7D3383C3CE944407DB77CE4DB758AD

Exchange 2007 Mastery Series: January 28, 2008
Three info-packed eLearning seminars for only $99 ($79 before December 15)!
Hosted by Windows IT Pro. Mark Arnold--MCSE+M, Microsoft MVP--will coach you
through Exchange 2007 storage solutions: planning for archiving and
compliance, optimizing your iSCSI network storage, and finding the sweet spot
between memory and spindles.
http://pentonmedia.whatcounts.com/t?ctl=703A5:6B7D3383C3CE944407DB77CE4DB758AD

Packed with thousands of articles, bonus content, and loads of expert advice,
the Windows IT Pro Master CD is like having your very own team of professional
Windows consultants in your pocket. Get real-world solutions lightning-fast--
order the Windows IT Pro Master CD today. Includes a one-year subscription to
all online content at WindowsITPro.com!
http://pentonmedia.whatcounts.com/t?ctl=703A8:6B7D3383C3CE944407DB77CE4DB758AD

==== Contact Us ====

About Scripting Central -- scriptingcentral@windowsitpro.com
About product news -- scriptingcentral@windowsitpro.com
About your subscription -- scripting_central@list.windowsitpro.com

=================================

This email newsletter is brought to you by Windows IT Pro, the leading
publication for IT professionals deploying Windows and related technologies.
Subscribe today!
http://pentonmedia.whatcounts.com/t?ctl=703A7:6B7D3383C3CE944407DB77CE4DB758AD

To ensure that future email messages you receive from Scripting Central
aren't mistakenly blocked by antispam software, be sure to add
scripting_central@list.windowsitpro.com to your list of allowed senders
and contacts.

Manage Your Account
You are subscribed as tayllorcriss@gmail.com

You are receiving this email message because you subscribed to this
newsletter on our Web site. To ***, click the *** link:
http://pentonmedia.whatcounts.com***id=6B7D3383C3CE944407DB77CE4DB758AD

View the Windows IT Pro Privacy Policy.
http://pentonmedia.whatcounts.com/t?ctl=703A9:6B7D3383C3CE944407DB77CE4DB758AD

Windows IT Pro is a division of Penton Media, Inc.
221 East 29th Street, Loveland, CO 80538, Attention: Customer Service
Department

Copyright 2007, Penton Media, Inc. All Rights Reserved.

Back to newsletter list

Date:

From:

Subject:

How to Find Constants and Their Values in WSH Scripts