Search found 34 matches

by drawback
15 May 2019, 03:53
Forum: Ask for Help (v1)
Topic: COM - Excel - Cell content = floating point? Topic is solved
Replies: 12
Views: 2674

Re: COM - Excel - Cell content = floating point? Topic is solved

Thanks guys (for the explanations as well)! I need to iterate over 20.000 cells so speed is crucial... In the end I've used a two step regex process where I first removed all trailing 000000 chars and reformatted the remaining ones (1232.03, 322.42 etc.) into 1232,03 & 322,42 (german divider for num...
by drawback
10 May 2019, 04:14
Forum: Ask for Help (v1)
Topic: COM - Excel - Cell content = floating point? Topic is solved
Replies: 12
Views: 2674

Re: COM - Excel - Cell content = floating point? Topic is solved

Yeah, I was already replacing that value
by using

Code: Select all

v := RegExReplace(v, "\.0{6}$")
but I was just wondering why the array is filled with floating point values when the real value is just an integer
(so that I can avoid the regexreplace).

There must be a reason for this...
by drawback
09 May 2019, 16:12
Forum: Ask for Help (v1)
Topic: COM - Excel - Cell content = floating point? Topic is solved
Replies: 12
Views: 2674

COM - Excel - Cell content = floating point? Topic is solved

Hi, some demo code: xl := ComObjCreate("Excel.Application") xl.Workbooks.Open("R:\test.xlsx") xl.Sheets("Test").Select xlContent := xl.ActiveSheet.UsedRange.Value Msgbox, % xlContent[13, 6] xl.Workbooks.Close() xl.Quit xl = xlContent will be an array of rows, columns that contain the values of each ...
by drawback
07 Jan 2017, 12:46
Forum: Ask for Help (v1)
Topic: Capture streaming cli output?
Replies: 2
Views: 808

Capture streaming cli output?

Hi, is it possible to read in the output line after line that a cli program creates (e.g. in a command prompt)? In this particular case I'd like to capture the output of rsync.exe (but not when it's finished but with every new line that it spits out) and display it in e.g. an edit field in a gui... ...
by drawback
25 Oct 2016, 07:28
Forum: Ask for Help (v1)
Topic: RegExReplace simple question
Replies: 2
Views: 879

Re: RegExReplace simple question

or {<x>}$ where <x> is an integer -> in your case {3}$
or if you want to ignore the comma and anything behind it e.g.:

Code: Select all

one := "1.532.245,33"
RegExMatch(one, "^[0-9.]+", two)
msgbox, % two
by drawback
22 Oct 2016, 08:59
Forum: Ask for Help (v1)
Topic: Icon in taskbar(toolbar)
Replies: 11
Views: 2922

Re: Icon in taskbar(toolbar)

Code: Select all

#Include TrayIcon.ahk

trayIcons := TrayIcon_GetInfo()

Loop, % trayIcons.MaxIndex()
	if (trayIcons[A_Index].process = "skype.exe")
		TrayIcon_Remove(trayIcons[A_Index].hwnd, trayIcons[A_Index].uid)

by drawback
20 Oct 2016, 15:07
Forum: Ask for Help (v1)
Topic: Regex help...
Replies: 8
Views: 2170

Re: Regex help...

@ahcahc
Thanks a lot, works!

@HelgeF
Very... evil! :)
by drawback
20 Oct 2016, 13:59
Forum: Ask for Help (v1)
Topic: Regex help...
Replies: 8
Views: 2170

Re: Regex help...

@evilC: Thank you!, but I guess I didn't describe it correctly :( This string can consist of any combination (and numbers!) of serial number / volume label / drive letter :\ [<path with ; in it] So these would be all "valid" strings that could occur: EED6-5BA8:\Us;e;rs;D:\Test;Storage:\A;B;C\ Storag...
by drawback
20 Oct 2016, 12:35
Forum: Ask for Help (v1)
Topic: Regex help...
Replies: 8
Views: 2170

Re: Regex help...

Could be quite difficult due to the different ways in which semicolon is used (Both as a field separator and a folder separator - how can it tell the difference?) The difference should be solvable by a positive lookahead (at least that was my plan...) Does EED6-5BA8:\Us;e;rs vary? Ofc. It could be ...
by drawback
20 Oct 2016, 12:09
Forum: Ask for Help (v1)
Topic: Regex help...
Replies: 8
Views: 2170

Regex help...

Hi, I have the following string: EED6-5BA8:\Us;e;rs;D:\Test;Storage:\A;B;C\ I know how to loop over it via RegExMatch but I need a bit of help to define the actual regex pattern... The string consists of three paths: 1.) EED6-5BA8:\Us;e;rs -> Drive serial number + folder with semicolons in it 2.) D:...
by drawback
20 Oct 2016, 05:57
Forum: Ask for Help (v1)
Topic: water-tight window activating sequence?
Replies: 1
Views: 788

Re: water-tight window activating sequence?

RunWait?
It waits until that program was quit!

Use WinWait instead of Sleep
by drawback
18 Oct 2016, 17:44
Forum: Ask for Help (v1)
Topic: Navigate Microsoft Management Console?
Replies: 0
Views: 701

Navigate Microsoft Management Console?

Hi, isn't it possible to navigate gpedit.msc (a MM console)? It has a SysListView321 on it's left side but I can't get any row text from it (with ControlGetText, var, List, , SysListView321, Editor für lokale Gruppenrichtlinien)... I'd really like to automate setting some group policies (which don't...
by drawback
14 Oct 2016, 17:37
Forum: Ask for Help (v1)
Topic: [SOLVED] Convert string to raw binary data?
Replies: 14
Views: 7493

Re: [SOLVED] Convert string to raw binary data?

@jNizM

Is there a way to get the unicode string back from the hex values (with a function like hex2str(hexValue)) after using str2hex("some unicode characters")?
by drawback
12 Oct 2016, 14:12
Forum: Scripts and Functions (v1)
Topic: AutoXYWH() - Move control automatically when GUI resized
Replies: 107
Views: 85408

Re: AutoXYWH() - Move control automatically when GUI resized

Are there any license restrictions (for using it in a commercial application) for this one?
by drawback
09 Oct 2016, 04:05
Forum: Ask for Help (v1)
Topic: Combination of GetKeyStates() -> Derive characters from it? Topic is solved
Replies: 3
Views: 1200

Combination of GetKeyStates() -> Derive characters from it? Topic is solved

Hi, shiftState := GetKeyState("Shift", "P") ? 1 : 0 ctrlState := GetKeyState("Ctrl", "P") ? 2 : 0 altState := GetKeyState("Alt", "P") ? 4 : 0 lWinState := GetKeyState("LWin", "P") ? 8 : 0 state := ctrlState + shiftState + altState + lWinState Is there a good way to get the corresponding modifier (^,...
by drawback
07 Oct 2016, 13:45
Forum: Ask for Help (v1)
Topic: OnMessage - Receive WM_LBUTTONDOWN event?
Replies: 5
Views: 2073

Re: OnMessage - Receive WM_LBUTTONDOWN event?

Sorry, you're right lexikos. I though about a specialized hook but a hotkey is sufficient in this case. Me culpa!
by drawback
06 Oct 2016, 17:31
Forum: Ask for Help (v1)
Topic: OnMessage - Receive WM_LBUTTONDOWN event?
Replies: 5
Views: 2073

Re: OnMessage - Receive WM_LBUTTONDOWN event?

Ok, thanks!

@lexikos:
Any hints how to implement this? I only need to listen for this event for a specific application (for example: Windows File Explorer)

Go to advanced search