Search found 11 matches

by Danton
Fri Aug 16, 2019 11:32 pm
Forum: Technical / Scripting
Topic: Issue with String replace
Replies: 3
Views: 2253

Re: Issue with String replace

Perfect. Thanks Dorian.
by Danton
Fri Aug 16, 2019 12:32 am
Forum: Technical / Scripting
Topic: Issue with String replace
Replies: 3
Views: 2253

Issue with String replace

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...
by Danton
Fri Aug 09, 2019 9:06 pm
Forum: Scripts and Tips
Topic: Debug from middle of Script
Replies: 3
Views: 6406

Re: Debug from middle of Script

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...
by Danton
Thu Aug 08, 2019 7:48 am
Forum: Scripts and Tips
Topic: Debug from middle of Script
Replies: 3
Views: 6406

Debug from middle of Script

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...
by Danton
Fri Nov 11, 2011 6:04 am
Forum: Beginners
Topic: Count matching string from clipboard
Replies: 3
Views: 8729

Thanks, that did the trick!
by Danton
Fri Nov 11, 2011 12:25 am
Forum: Beginners
Topic: Count matching string from clipboard
Replies: 3
Views: 8729

Count matching string from clipboard

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 :D
by Danton
Fri Aug 27, 2010 11:26 pm
Forum: Beginners
Topic: Deconstruct string
Replies: 6
Views: 7134

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...
by Danton
Thu Aug 26, 2010 10:25 pm
Forum: Beginners
Topic: Deconstruct string
Replies: 6
Views: 7134

Thanks,

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

Thanks for the tip on xlGetcell too..


Danton
by Danton
Thu Aug 26, 2010 5:04 am
Forum: Beginners
Topic: Deconstruct string
Replies: 6
Views: 7134

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...
by Danton
Thu Aug 26, 2010 3:56 am
Forum: Beginners
Topic: Deconstruct string
Replies: 6
Views: 7134

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...
by Danton
Thu Aug 26, 2010 12:15 am
Forum: Beginners
Topic: Deconstruct string
Replies: 6
Views: 7134

Deconstruct string

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...
Sign up to our newsletter for free automation tips, tricks & discounts