 | | | VBS - Fixing Text | VBS - Fixing Text 2004-03-01 - By Robert Moodie
Back
I know Trim(input) will strip out the spaces, not sure about the rest. Have you
checked the Windows Script docs?
Or maybe some kond of Replace syntax...
_rob
-- -- Original Message -- --
From: Nick Petit
To: XSI
Sent: Monday, March 01, 2004 5:39 AM
Subject: [Script] VBS - Fixing Text
Hiya,
I'm having a slight brain fart at the moment and can't seem to figure out how
to get this going...
I'm retrieving text from user input (from a text file or whatever) and I don
't want to limit the user to have to watch out for his spelling by having to not
put in spaces, numbers at the head of the word nor special characters...
How do I strip a string of all the numbers, spaces and special characters and
replace them with an underscore?
The replace function won't accept [^a-z]...
I've managed to get the script going another way but I'm now curious as to
how to do the above...
Cheers!
Nick.
Nick Petit
Lead 3D/TD
F U S E D D D @ M R P P P
20 Thistlethwaite St
South Melbourne
3205 VIC
Australia
http://www.mrppp.com.au
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859 (See http://iso-8859.ora-code.com)-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I know Trim(input) will strip out the spaces, not
sure about the rest. Have you checked the Windows Script docs?</FONT></DIV>
<DIV><FONT face=Arial size=2>Or maybe some kond of Replace
syntax...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>_rob</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
#000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">-- -- Original Message -- -- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Nick@(protected) href="mailto:Nick@(protected)">Nick Petit</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=XSI@(protected)
href="mailto:XSI@(protected)">XSI</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, March 01, 2004 5:39
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Script] VBS - Fixing Text</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hiya, </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm having a slight brain fart at the moment and
can't seem to figure out how to get this going...</FONT></DIV>
<DIV><FONT face=Arial size=2>I'm retrieving text from user input (from a text
file or whatever) and I don't want to limit the user to have to watch out for
his spelling by having to not put in spaces, numbers at the head of the word
nor special characters...</FONT></DIV>
<DIV><FONT face=Arial size=2>How do I strip a string of all the numbers,
spaces and special characters and replace them with an underscore?
</FONT></DIV>
<DIV><FONT face=Arial size=2>The replace function won't accept [^a-z]...
</FONT></DIV>
<DIV><FONT face=Arial size=2>I've managed to get the script going
another way but I'm now curious as to how to do the above... </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Cheers!</FONT></DIV>
<DIV><FONT face=Arial size=2>Nick.</FONT></DIV>
<DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><FONT color=#808080>Nick Petit<BR></FONT><FONT
color=#800000><FONT color=#808080>Lead 3D/TD</FONT><BR><STRONG>F U S
E D D D @ M R P P P<BR></STRONG></FONT><FONT color=#808080
size=1>20 Thistlethwaite St<BR>South Melbourne<BR>3205
VIC<BR>Australia</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><A
href="http://www.mrppp.com.au">http://www.mrppp.com.au</A></FONT></DIV></DIV>
</DIV></BLOCKQUOTE></BODY></HTML>
|
|
|