Technical support and scripting issues
Moderators: JRL, Dorian (MJT support)
-
Bilde
- Junior Coder
- Posts: 31
- Joined: Fri Nov 15, 2002 3:19 pm
- Location: Denmark
Post
by Bilde » Wed Apr 16, 2003 9:43 pm
Is it possible to make a script that could change "_" to a space: " ".
for example:
"this_is_the_text" ---> "this is the text"
anyone?

-
Bob Hansen
- Automation Wizard
- Posts: 2475
- Joined: Tue Sep 24, 2002 3:47 am
- Location: Salem, New Hampshire, US
-
Contact:
Post
by Bob Hansen » Thu Apr 17, 2003 12:52 am
Easiest solution is to use Visual Basic Replace function
=================
VBSTART
VBEND
Let>String1=This_is_the_text.
VBEval>Replace("%String1%","_"," "),String2
Message>%String1%%CRLF%%CRLF%has been changed to %CRLF%%CRLF%%String2%
==================
There is no need to rename the result. It was just done here to display a message. The next line is perfectly acceptable:
VBEval>Replace("%String1%","_"," "),String1
Hope this helps, good luck.....
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!
-
Bilde
- Junior Coder
- Posts: 31
- Joined: Fri Nov 15, 2002 3:19 pm
- Location: Denmark
Post
by Bilde » Thu Apr 17, 2003 5:55 am
Thx, I'll take a look at it

-
Bilde
- Junior Coder
- Posts: 31
- Joined: Fri Nov 15, 2002 3:19 pm
- Location: Denmark
Post
by Bilde » Sun Apr 20, 2003 8:58 pm
I'd like to learn more about the VB features in Macro Scheduler, is there a tutorial, a command reference (like the excellent one in macro scheduler), or some kind of help site around?

-
Bob Hansen
- Automation Wizard
- Posts: 2475
- Joined: Tue Sep 24, 2002 3:47 am
- Location: Salem, New Hampshire, US
-
Contact:
Post
by Bob Hansen » Sun Apr 20, 2003 10:02 pm
See an answer to this under "VB Basics" that I just added as a new Subject to answer your question. I just thought it should have its own Subject listing.
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!
-
support
- Automation Wizard
- Posts: 1450
- Joined: Sat Oct 19, 2002 4:38 pm
- Location: London
-
Contact:
Post
by support » Mon Apr 21, 2003 10:49 am
Hi,
Yes, there are tutorials galore at Microsoft's web site along with the function reference which can be downloaded or viewed on the web. Our VBScript Resource page links to these and more:
http://www.mjtnet.com/resources.htm