View topic - Junk captured by clipboard or ControlSendText • AutoHotkey Community

View unanswered posts | View active topics

Board index » AutoHotkey » Support

All times are UTC [ DST ]

Junk captured by clipboard or ControlSendText

Page 1 of 1

[ 4 posts ]

Print view | E-mail friend

Previous topic | Next topic

Author

Message

tekkie2412

Post subject: Junk captured by clipboard or ControlSendText

Posted: October 22nd, 2009, 11:41 pm

Joined: May 22nd, 2007, 1:06 am
Posts: 73

Im copying data from a spreadsheet via ^c (OpenOffice currently), about 10 values, then sending the value using ControlSendText to another application. The values all go to the correct controls on the application, but there is always trailing garbage. For example, if I have it copy "123 Sesame Street" from the spreadsheet, ControlSetText sends "123 Sesame Street□□". If I paste into the browser or notepad it looks correct, so I dont think its happening in the clipboard. Any suggestions?

Thanks

Top

Leef_me

Post subject:

Posted: October 22nd, 2009, 11:59 pm

Joined: April 8th, 2009, 7:49 pm
Posts: 6065
Location: San Diego, California

I suggest that the junk is CR/LF http://www.autohotkey.com/docs/misc/Clipboard.htm

Quote:

Each line of text on Clipboard typically ends with carriage return and linefeed (CR+LF), which can be expressed in the script as `r`n.

Ths script will illustrate and possibly give you an idea how to proceed.
Select a cell in the spreadsheet and then hit Win-q

Code:

#q:: ; win-q hotkey
Send ^c
clipwait, 1,1

msgbox before '%clipboard%'

StringReplace, clipboard, clipboard,`r`n,,all

msgbox after '%clipboard%'

An alternative is to use COM, which I have not explored
http://www.autohotkey.com/forum/viewtop ... =excel+com

Top

tekkie2412

Post subject:

Posted: October 23rd, 2009, 12:12 am

Joined: May 22nd, 2007, 1:06 am
Posts: 73

Ah yes, I forgot about string replace. I was trying all these and going nuts. The stringreplace works semi-perfectly

Code:

ControlSetText, control, %Name%`r`n, WinName
ControlSend, control, %Name%, WinName
ControlSendRaw, control, %Name%, WinName

Top

Leef_me

Post subject:

Posted: October 23rd, 2009, 2:41 am

Joined: April 8th, 2009, 7:49 pm
Posts: 6065
Location: San Diego, California

Quote:

The stringreplace works semi-perfectly

Ok, how do we get a higher score than "semi" ? :wink:

Top

Page 1 of 1

[ 4 posts ]

Board index » AutoHotkey » Support

All times are UTC [ DST ]

Who is online

Users browsing this forum: Google [Bot], hyper_, JSLover, Leef_me, oldbrother, patgenn123 and 64 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum