 | | | VBS - Fixing Text | VBS - Fixing Text 2004-03-01 - By Nick Petit
Back
Cheers Rob, the trim function only trims at the head and the end, so for
example:
Trim(" Bob and Jane ") 'results in "Bob and Jane", the spaces in between
Bob and Jane are still there... fixed with a split function and a join with "_"
However the problem is I want to catch any kind of special character and
numbers... " ' ? > & # ^ @ ! 1 2 3 etc etc...
The replace function won't let me delimit what to replace with the normal
pattern property [^a-z]
I might try and imbed a Jscript function, as Kim suggested... :)
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
-- -- Original Message -- --
From: Robert Moodie
To: XSI@(protected)
Sent: Tuesday, March 02, 2004 1:31 AM
Subject: Re: [Script] VBS - Fixing Text
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.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Cheers Rob, the trim function only trims at the
head and the end, so for example:</FONT></DIV>
<DIV><FONT face=Arial color=#ff0000 size=2>Trim<FONT
color=#000000>(" Bob and Jane ") <FONT
color=#008000>'results in "Bob and Jane", the spaces in between Bob and Jane
are
still there... fixed with a split function and a join with
"_"</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial color=#ff0000 size=2><FONT
color=#000000></FONT></FONT> </DIV>
<DIV><FONT face=Arial size=2>However the problem is I want to catch any kind of
special character and numbers... " ' ? > & # ^ @ ! 1 2 3 etc
etc... </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The replace function won't let me delimit what to
replace with the normal pattern property [^a-z]</FONT></DIV>
<DIV><FONT face=Arial size=2>I might try and imbed a Jscript function, as Kim
suggested... :)</FONT></DIV>
<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><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<DIV><FONT face=Arial size=2></FONT> </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 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=robertm@(protected) href="mailto:robertm@(protected)">Robert
Moodie</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=XSI@(protected)
href="mailto:XSI@(protected)">XSI@(protected)</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, March 02, 2004 1:31
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Script] VBS - Fixing
Text</DIV>
<DIV><BR></DIV>
<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></BLOCKQUOTE></BODY></HTML>
|
|
|