letter replacement

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
Bilde
Junior Coder
Posts: 31
Joined: Fri Nov 15, 2002 3:19 pm
Location: Denmark

letter replacement

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? :)

User avatar
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? :)

User avatar
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!

User avatar
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
MJT Net Support
[email protected]

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts