Candyce_ Posted January 30, 2007 Report Share Posted January 30, 2007 helo, i have a list of number with space ( 1 223 458 ) and i would like to copy and paste it without space (1223458). Can i do it with ME ? Thank you and sorry for my bad english. Quote Link to comment Share on other sites More sharing options...
kevin Posted January 30, 2007 Report Share Posted January 30, 2007 Yes, you can. Write a macro to do these steps: Copy the item to the clipboard Do Replace " " with "" in %T1% Paste The 'Replace' step replaces one or more spaces with an empty value. This removes all spaces. Quote Link to comment Share on other sites More sharing options...
Candyce_ Posted January 30, 2007 Author Report Share Posted January 30, 2007 thank you for your quick answer. Can you tell where is the replace command, i don't find it. Sorry and thank you Quote Link to comment Share on other sites More sharing options...
jason Posted January 30, 2007 Report Share Posted January 30, 2007 The replace is found in the Variable Modify String command. Click on the option to Replace String. Select the variable that you want to modify and enter a space in the Text To Replace field and then leave the Replace With field blank. You will also need to check Replace All Instances checkbox. Quote Link to comment Share on other sites More sharing options...
Candyce_ Posted January 30, 2007 Author Report Share Posted January 30, 2007 thank you i find the command but this one was working 4 times, after it is paste a blank line. i join the code : <MMW2:390,99><LCLK><CLIPE><TDELAY:3><MMW2:630,97><LDCLK><TVAR2:99:03:><TMVAR2:21:99:01:001:000: ><ACTIVATE2:Excel -><MSD:5><MMW2:235,486><LCLK><TEXTTYPE:%T99%><MSD:5><MMW2:389,484><LCLK> thank you Quote Link to comment Share on other sites More sharing options...
terrypin Posted January 31, 2007 Report Share Posted January 31, 2007 I'm a novice myself, but I'm pretty sure the reason it fails and gives you a blank line is because it's blank to start with - due to your Clipboard Empty command! I tried this code <TVAR2:99:03:><TMVAR2:21:99:01:001:000: ><ACTIVATE2:Textpad><TEXTTYPE:%T99%> in Notepad and it worked fine. -- Terry, West Sussex, UK Quote Link to comment Share on other sites More sharing options...
wbeldman Posted January 31, 2007 Report Share Posted January 31, 2007 Mouse Move Window 390, 99 Mouse Left Button Click Clipboard Empty Wait Time Delay 3 Seconds Mouse Move Window 630, 97 Mouse Left Button Double Click Should there be some copy command here? Like: Clipboard Copy or: // Context menu -- Copy Mouse Right Button Click Text Type: c Variable Set String %T99% from Clipboard Replace " " with "" in %T99% Activate Window: "Excel -" Delay 5 Milliseconds Mouse Move Window 235, 486 Mouse Left Button Click Text Type: %T99% Delay 5 Milliseconds Mouse Move Window 389, 484 Mouse Left Button Click Text Type: Quote Link to comment Share on other sites More sharing options...
Candyce_ Posted February 1, 2007 Author Report Share Posted February 1, 2007 Thank you all It is working fine now. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.