Intelligent Automation & Macro Software  

Go Back   Automation Anywhere, Inc. Forums > Products Zone > Automation Anywhere
Register FAQ Search Today's Posts Mark Forums Read

Automation Anywhere Post messages and questions related to Automation Software here.


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-22-2009, 05:18 PM
GMPLLC GMPLLC is offline
Junior Member
 
Join Date: Jun 2009
Posts: 25
Default Convert blank spaces to underscore in text string

I have a dynamic text string...(it is never the same) and I need to convert the blank spaces to underscores. For example....how do I convert the following text string;

'hj fdsffsf jojjkpko rewrrwrw'

...to the following -

'hj_fdsffsf_jojjkpko_rewrrwrw'


(Remember the text and the structure of the string is never the same)
Thanks in advance.
TK
Reply With Quote
  #2 (permalink)  
Old 11-23-2009, 08:42 AM
forumsupport forumsupport is offline
Senior Member
 
Join Date: Apr 2007
Posts: 1,342
Default

Hello,


You can create a simple vb script that would replace the space with underscore in any given string. You can call VB Script using 'Run Script' command of Automation Anywhere. Youcan pass parameter and can get return value in a user variable using this command.

For your convenience, we have created a sample task. To run this task,

. Please copy .atmn under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Copy .vbs under C:\.
. Run the task.

Task would display the resultant string in a message box.

Hope that helps.
Attached Files
File Type: zip Sample4GMPLLC.zip (735 Bytes, 13 views)
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT -7. The time now is 09:51 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.0.0 ©2007, Crawlability, Inc.
Copyright © 2003-2011 Automation Anywhere, Inc. All rights reserved