Search found 82 matches

by carno
29 Oct 2017, 14:31
Forum: Ask For Help
Topic: RegExFind help request for an Excel spreadsheet Topic is solved
Replies: 4
Views: 72

Re: RegExFind help request for an Excel spreadsheet Topic is solved

teadrinker wrote:For AHK this works:

Code: [Select all]GeSHi © Codebox Plus

str := "-2,340.53 (-0.29%)"
RegExMatch(str, "[^\(]+(?=\))", match)
MsgBox, % match

So you could try =RegExpFind(A1,"[^\(]+(?=\))")

Thanks, now it works! :)
by carno
29 Oct 2017, 13:34
Forum: Ask For Help
Topic: RegExFind help request for an Excel spreadsheet Topic is solved
Replies: 4
Views: 72

Re: RegExFind help request for an Excel spreadsheet Topic is solved

Try =RegExpFind(A1,".+\(\K[^\)]+") Unfortunately, this didn't work. The only way I can make it work now is a 2 step process that I'd like to combine into one single formula; First, =RegExpFind(A1,"[^\s\$]+") gives me (-0.29%) in cell B1 (for A1 example 1). I then...
by carno
29 Oct 2017, 02:48
Forum: Ask For Help
Topic: RegExFind help request for an Excel spreadsheet Topic is solved
Replies: 4
Views: 72

RegExFind help request for an Excel spreadsheet Topic is solved

This is for an Excel spreadsheet. I tried the formula below to get contents inside the parentheses but not the parenthesis, and it does not work. Could you provide the correct expression? (Note: Formula { =RegExpFind(A1,"\(.+\)") } works but it includes the parentheses: Finds (-0.29%) for ...
by carno
21 Oct 2017, 20:56
Forum: Scripts and Functions
Topic: Detect if Mouse Moved Event function Lib
Replies: 2
Views: 149

Re: Detect if Mouse Moved Event function Lib

This is one way that I came up with: #SingleInstance, Force #Persistent Loop { MouseGetPos, MouseX1, MouseY1 Loop { MouseGetPos, MouseX2, MouseY2 If (MouseX2 <> MouseX1) || (MouseY2 <> MouseY1) { ToolTip, 1 SetTimer, RemoveToolTip, 250 Break } } } return RemoveToolTip: SetTimer, RemoveToolTip, Off ...
by carno
11 Oct 2017, 20:03
Forum: Ask For Help
Topic: RegEx to find variable dollar amount in a wall of text Topic is solved
Replies: 3
Views: 89

Re: RegEx to find variable dollar amount in a wall of text Topic is solved

I'm just learning RegExMatch but this is what I figured out so far. Probably a more efficient way yet hopefully someone can school us both! note= ( ... stuff here blah blahblhablhablah sklchsldkn klcnaslnk 2345 34 5 333 Based on past jobs we think we can get this job done for 5 USD (excl. tax) but ...
by carno
11 Oct 2017, 16:11
Forum: Ask For Help
Topic: RegEx to find variable dollar amount in a wall of text Topic is solved
Replies: 3
Views: 89

Re: RegEx to find variable dollar amount in a wall of text Topic is solved

Hi, magicinmath, thanks for the effort, but this fails when I paste my wall of text. There are many other numerals before and after the sentence I highlighted in red (see above). I am seeking just the number (no USD) in that particular sentence I highlighted in red that is somewhere in the wall of t...
by carno
11 Oct 2017, 15:13
Forum: Ask For Help
Topic: RegEx to find variable dollar amount in a wall of text Topic is solved
Replies: 3
Views: 89

RegEx to find variable dollar amount in a wall of text Topic is solved

I have the following sentence in a wall of text where I want to extract an embedded variable dollar amount (could be 1 to 3 digits) between [... done for] and [USD (excl. tax) but...], so in the following case this number should be [50]. What would be the most efficient way to achieve this using Reg...
by carno
17 Sep 2017, 22:09
Forum: Scripts and Functions
Topic: Custom text wrapping script
Replies: 4
Views: 294

Re: Custom text wrapping script

I would like to see the hotkey you wrote that utilizes this script. Please post that too with an example how to do it.
by carno
25 Jul 2017, 12:35
Forum: Scripts and Functions
Topic: Permutations()
Replies: 5
Views: 461

Re: Permutations()

Any real examples?
by carno
25 Jul 2017, 10:30
Forum: Scripts and Functions
Topic: How to perfectly fit any image on a fixed size picture control
Replies: 24
Views: 1334

Re: How to perfectly fit any image on a fixed size picture control

Works perfectly!
AutoHotkey : v1.1.24.04 Unicode 32-bit (Installed)
SystemOS : WIN_XP 32-bit Service Pack 2 v5.1.2600 (WIN32_NT)
by carno
07 May 2017, 02:40
Forum: Scripts and Functions
Topic: AHK/PowerShell email sender
Replies: 5
Views: 596

Re: AHK/PowerShell email sender

Do you have a version for receiving emails, too?
by carno
27 Apr 2017, 22:35
Forum: Scripts and Functions
Topic: FindClick() - ImageSearch, Clicking, & More [Newest Version]
Replies: 38
Views: 11115

Re: FindClick() - ImageSearch, Clicking, & More [Newest Version]

I confirm the typo in FINDCLICK DOCUMENTATION Function by Berban Last updated June 14, 2013: FindClick("C:\MyImage.png", "n", xCoord, yCoord) MsgBox, The x-coordinate of the image is %xCoord% MsgBox, The x-coordinate of the image is %yCoord% ; This should be: MsgBox, The y-coordi...
by carno
18 Mar 2017, 23:51
Forum: Ask For Help
Topic: Removing all leading numbers in strings
Replies: 6
Views: 481

Re: Removing all leading numbers in strings

Thanks again! Great posts with pitfall tips and RegEx that could handle them.
by carno
18 Mar 2017, 19:30
Forum: Ask For Help
Topic: Removing all leading numbers in strings
Replies: 6
Views: 481

Re: Removing all leading numbers in strings

Thanks very much! I tested and it works great.
by carno
18 Mar 2017, 17:28
Forum: Ask For Help
Topic: Removing all leading numbers in strings
Replies: 6
Views: 481

Removing all leading numbers in strings

I have a list as follows. I would like to have a script that strips all the leading numbers (and any spaces, etc.) at the beginning of each line: 1 Best Checking Account Bonuses 1.1 Citi $300 Bonus – No Direct Deposit Required 1.2 My Banking Direct $150 Bonus [Nationwide Excluding AZ, FL, NY, NJ or ...
by carno
16 Mar 2017, 14:50
Forum: Scripts and Functions
Topic: GDIP magnifier
Replies: 9
Views: 2574

Re: GDIP magnifier

Thanks! One of the best.
by carno
17 Feb 2017, 08:40
Forum: Scripts and Functions
Topic: time calculator
Replies: 6
Views: 1062

Re: time calculator

@rommmcek: Thanks, I didn't notice your script: ; https://www.autohotkey.com/boards/viewtopic.php?f=6&t=28163 #NoEnv #SingleInstance Force /* 1.12+15+95-2-1.0-1.9=0:51 = 1:12+0:15+1:35-0:02-1:00-1:09=0:51 */ MsgBox Press OK and then ^numpad1 (Ctrl+Numpad1) to start this script HP := HT := 0, His...
by carno
16 Feb 2017, 21:28
Forum: Scripts and Functions
Topic: time calculator
Replies: 6
Views: 1062

Re: time calculator

Can this be modified to accept 1:12+0:15+1:35-0:02-1:00-1:09 directly?

Go to advanced search