Spliiting Clipboard Text

[locutus243]

Hiya all,

I have used AutoIT to copy a cell from Excel that contains three numbers. I then want to enter this text into another program but the field I am entering it in won't let me copy form excel.

Therefore I need to manually enter the data that is on the clipboard.

E.g. If the cell I am copying contains the number 311, I want to be able to copy the cell, and then rather than using Clipput, I want to tell autoIT to enter the numbers as if I were using the Send function.

(I can't simply use the send function because the number is different each time so I would have to manually change the script every time, therefore losing the idea of autoscripting.)

Is there any way that I can get autoit to split up what is on the clipboard so it recognises the individual characters it has copied and is able to send these individually???

Thanks

Mark

[LxP]

Couldn't you just send all three numbers at once?

; '1' signals not to interpret any characters specially
 send(clipGet(), 1)

Edit: To do what you describe, StringSplit() if called with an empty delimiter string will return an array where each element is a character from the original string.

Edited September 27, 2005 by LxP

[locutus243]

Hi,

Thanks for your help. I tried experimenting with the stringsplit idea and I think it will work. But am having real trouble with that function. It keeps saying that I don't have the correct number of parameters in my function call. I have included the function below, wondered if you could spot my problem??

Thanks

Mark

Func Five()

WinActivate("Microsoft Excel - Book2")

Send("^c")

$bak = ClipGet()

MsgBox(0, "Clipboard contains:", $bak)

$array = StringSplit($bak,"",1)

MsgBox(0, "Clipboard contains:", $array)

EndFunc

Hey,

I seemed to have found what I was doing wrong. Thanks for your help

Mark