AutoHotkey Community

AlphaBravo

just me wrote: ↑
19 Feb 2019, 03:49
Not quite.
RegEx - Quick Reference wrote:\w ... This is equivalent to [a-zA-Z0-9_]. ...

fair enough

AlphaBravo

I am guessing this is what you're looking for variable = abcd-567 ; or 12abcd-567 if RegExMatch(variable,"((?:\d|\w)+)-(\d+)",vars) msgbox,% vars1 . "_" . vars2 ; or if RegExMatch(variable,"((\d|\w)+)-(\d+)",vars) msgbox,% vars1 . "_" . vars3 ; or variable = 12abcd-567 if RegExMatch(variable,"(\w+)-...

AlphaBravo

try this

Code: Select all

path := "c:\a.xlsx"
WB := ComObjGet(path)
xl := WB.Application

AlphaBravo

try the following, it didn't change encoding for me File := A_ScriptDir . "\Test.txt" ; Encoding unknown! AddStr := "Add this line." file := FileOpen(File, "rw") if !IsObject(file) { MsgBox Can't open "%File%" return } fileContents := file.Read() file.Position := 0 file.Write(AddStr "`r`n" fileConte...

AlphaBravo

LV_GetNext()

AlphaBravo

this code is based on the assumption that all lines end with "ClearDX" HTN := "HTN,CBC,CMP" ;,ClearDX" HLD := "HLD,CMP,Lipid_Pane" ;,ClearDX" T2DM := "T2DM,A1c,CMP,UrineMA" ;,ClearDX" Anemia := "Anemia,CBC,Ferritin,TIBC" ;,ClearDX" Diags_Present := "HLD,T2DM," ; example present := [] for each, diag ...

AlphaBravo

this If ((character ~= "p|.")) means "p" or anything, change to If ((character ~= "p|\."))

AlphaBravo

Code: Select all

string = sd12354fg14582gh25468jj54582rr45821lk45896qq7854
MsgBox % string := Trim(RegExReplace(string , "[a-zA-Z]+\d+", "$0 "), " ")

AlphaBravo

Screen Clipping

AlphaBravo

to catch other domains as well as ".com"

Code: Select all

myVariable =
(
Input: https://mysite.myorginzation.com:8443
Input: https://mysite.myorginzation.org/page/app.aspx
Input: ftp://mysite.myorginzation.net
)

while pos := RegExMatch(myVariable, "://\K([^/:\s]+)", m, A_Index=1?1:pos+StrLen(m))
	MsgBox % m1

AlphaBravo

I've been using AHK for years now What took you so long to register ;) csv1 = ( DRIVE NAME,USERS ENGINEERING,jim,joe,sally FILESHARE,greg,joe,sally HOME,greg,jim,joe,sally ) csv2 = ( DRIVE NAME,USERS CONTRACTS,bob,tina ENGINEERING,bob,frank,tina FILESHARE,bob,frank,ross HOME,bob,frank,haley,ross,ti...

AlphaBravo

I offered a solution few years ago here
//autohotkey.com/board/topic/99522-search-image-closest-to-the-center/?p=624538

AlphaBravo

I don't mean to pick on you sinkfaze, but there is a flaw in the answer due to the use of StrReplace() try it on this input a= ( 1 2 3 32 2 1 ) b := a elements := [] loop, parse, b, `n, `r elements[A_LoopField] := elements[A_LoopField] ? elements[A_LoopField] + 1 : 1 for element, count in elements i...

AlphaBravo

awel20 , Thanks for taking the time to elaborate on that and your input. Unfortunately the only thing I can suggest is making sure your script is running with the same level of privileges as Outlook. just like you suggested when I ran outlook with elevated privilege (run as admin) I was able to get ...

AlphaBravo

I am working on a script that needs to run as admin, and came across the issue with ComObjActive not working with Outlook when elevated.
I found few posts discussing it but still did not find a solid solution.
has anyone got Acc_ObjectFromWindow to work on Outlook?

AlphaBravo

Hello IMEime, I have noticed your reference to this script from "Comparing 2 excel Files takes Forever to finish" request, I gave it a bit of testing and while it is for sure faster than iterating through Excel cells via COM, I noticed that if a cells is formatted (Bold/Italic/Underlined/formatted a...

AlphaBravo

no worries, this should do it, I added a couple of lines oWord := {"à":"a", "á":"a", "ã":"a", "â":"a", "é":"e", "è":"e", "ê":"e" , "í":"i", "ì":"i", "ó":"o", "õ":"o", "ô":"o", "ò":"o", "ú":"u" , "ù":"u", "ç":"c", "À":"A", "Á":"A", "Ã":"A", "Â":"A", "É":"E" , "Ê":"E", "È":"E", "Í":"I", "Ì":"I", "Ó":"...

AlphaBravo

hello again, I see the issue, modified the script a little bit oWord := {"à":"a", "á":"a", "ã":"a", "â":"a", "é":"e", "è":"e", "ê":"e" , "í":"i", "ì":"i", "ó":"o", "õ":"o", "ô":"o", "ò":"o", "ú":"u" , "ù":"u", "ç":"c", "À":"A", "Á":"A", "Ã":"A", "Â":"A", "É":"E" , "Ê":"E", "È":"E", "Í":"I", "Ì":"I",...

AlphaBravo

(Instead of 2200 it could be the actual range, but 2200 should be enough in my case). what is the actual range ?? if the "actual range" is the last cell with data in the active column and is likely to be at a row number less than 2200 xl := ComObjActive("Excel.Application") col := xl.ActiveCell.Col...

AlphaBravo

look at StrSplit

Search found 460 matches

Re: regex question Topic is solved

Re: regex question Topic is solved

Re: How to get handle to specific excel file among multiple opened excel files?

Re: How to add text to a text file (encoding!) Topic is solved

Re: How to get the line number of the currently selected row in the Listview? Topic is solved

Re: HELP: Strings? Arrays? A-Arrays?

Re: I need help to see why my label containing an if statement doesn't get triggered. Topic is solved

Re: parse a string with regex delimiter

Re: Help with screen snipping

Re: Extract hostname from URL?

Re: Script to Concatenate two CSVs

Re: Search for the nearest picture starting from the center of the window

Re: How to find duplicate lines? Topic is solved

Re: Outlook in Windows 10 - UAC Issues Topic is solved

Re: Outlook in Windows 10 - UAC Issues Topic is solved

Re: Reads Excel (xlsx) Fast

Re: Script to rename files Topic is solved

Re: Script to rename files Topic is solved

Re: RegExReplace - Address of Excel cell + Range Topic is solved

Re: Single Cell - Multiple Output Topic is solved