Perfect. Thanks Dorian.

The code below is meant to get ten numbers from Excel. There is a String replace line that is used to remove CRLF characters. Looking at the watch list the number is extracted from EXCEL. This is watch I see in the watchlist INBOUNDNUMBER1=8001234567 The result of the String replace line is as follo...

Thanks for the tips. I ended up doing the following. Simply commenting out the first few subroutines that I know work so the subroutine I'm testing is executed first. Putting a wait in the script before the critical step so I could place the application in the state before the failing step. I did ha...

I'm trying to debug a script. I'm repeatively getting stuck at the same page of an application. I want to skip the first steps, and test from the point the script is getting stuck. I have tried stepping through the code in the editor but that does not seem to work as the application is in the backgr...

Thanks, that did the trick!

Hi all,

the script I'm writing needs to count the number of matching "strings" in clipboard.

so how do I search the contents of the clipboard and return the number of matches for a string eg number of times "green rabbit" appears in the clipboard.

Thanks

The count is in items_count. Separate produces items_1 ... items_n plus items_count So you can loop through the array: Let>k=0 Repeat>k Let>k=k+1 Let>this_item=items_%k% ... Until>k=items_count And I would use XLGetCell and XLSetCell rather than DDERequest/DDEPoke Strange. For some reason DDEReques...

Thanks,

I'm learning
I got close in my attempt, but not close enough.

Thanks for the tip on xlGetcell too..


Danton

Try this: Let>String=CUST="26082"&"29185"&"35247"&"45407"&"65488"&"72471"&"110082" Position>=",String,1,nPos,TRUE Add>nPos,1 Length>String,nLength MidStr>String,nPos,nLength,strSub Separate>strSub,&,Items This will return an array of variables, i.e. ITEMS_1="26082" ITEMS_2="29185" ITEMS_3="35247" I...

Try this: Let>String=CUST="26082"&"29185"&"35247"&"45407"&"65488"&"72471"&"110082" Position>=",String,1,nPos,TRUE Add>nPos,1 Length>String,nLength MidStr>String,nPos,nLength,strSub Separate>strSub,&,Items This will return an array of variables, i.e. ITEMS_1="26082" ITEMS_2="29185" ITEMS_3="35247" I...

Hi All, I'd like to deconstruct a string and get all the variables contained with in it. I'm sure there's a "clever" way to do it. The pattern is always the same; the variables are contained within quotes after the "=", separated by the &. The name at the begining can change and is not that importan...