AutoHotkey Community

flyingDman

I do not believe that var := '"abc,def" ghi,jkl' is a proper CSV. Whether like this or with linefeeds in between. It is not properly parsed and ghi is ignored (run the code above). If double quotes are used they should be around the entire field ("enclosing the field"). RFC-4180 says "If double-quot...

flyingDman

I doubt the Python CSV library plays nicely with malformed CSV files...

flyingDman

Centrer une fenetre, CMD ou autre: f12:: Run, %comspec% /k dir *.* Winwaitactive ahk_exe WindowsTerminal.exe WinGetPos, , , w, h, ahk_exe WindowsTerminal.exe WinMove, ahk_exe WindowsTerminal.exe,, % (A_ScreenWidth - w) // 2, % (A_ScreenHeight - h) // 2 Integrer ce code dans le fichier .bat? Le conce...

flyingDman

Don't expect loop parse "CSV" to work on a malformed CSV file.
This is not going to work:

Code: Select all

var := '"abc,def" ghi,jkl'
Loop parse, var, "CSV"
	msgbox a_loopfield

The double quotes have to be around the entire field.

flyingDman

Be careful with compounded first names. What if you have a first name like Billy Jean or T.J. or Daisy-Mae. Are you sure you want to have those names as Billy or T or Daisy?

flyingDman

I don' t understand. This still works as expected:
str := '8181818^Lname/Fname ^1818181'
MsgBox LName := StrSplit(str,['^','/'])[2]
Is that not the intended result?

flyingDman

Code: Select all

str := "blahblahblah=YYMMblahblahblah"
msgbox year := substr(str,instr(str,"=")+1,2)
msgbox month := substr(str,instr(str,"=")+3,2)

flyingDman

I'd use:

Code: Select all

#+c::
	{
	a_clipboard := ""	
	send "^c"
	if clipwait(1)
		{	
		z := regexreplace(a_clipboard,"`n`r","`n")
		arr := strsplit(z,"`n`n","`r") 
		MsgBox(a:=arr[1] b:=arr[2])
		}
	}

If you have more than 2 paragraphs use Join (https://www.autohotkey.com/docs/v2/Functions.htm#Variadic)

flyingDman

or:

Code: Select all

str := '%B1111222233334444^LastName/FirstName'
MsgBox LName := StrSplit(str,['^','/'])[2]

flyingDman

I do not understand the question or the problem. You will determine in you script whether the Listiview has checkboxes or not. If it does have checkboxes you can use the modified Class so that a rightclick edits the cell and a doubleclick checks the box. If it does not have checkboxes you can use th...

flyingDman

Short answer: you can't. I would do something like this. Check / uncheck using doubleclick and edit using right click. g := Gui("+AlwaysOnTop") LV := g.AddListView("w200 r12 -readonly checked", ["name","items"]) loop 12 LV.Add(, "Name " A_Index,"Item " A_Index * 10) LV.modifycol(1, 90) LV.modifycol(...

flyingDman

I don't know.

flyingDman

If you search the forum on Excel or Word, you'll see many post that include COM (googling site:autohotkey.com Excel COM shows > 15K results). Yes, we are very definitively still in Autohotkey! AHK natively includes the ability to interface with applications that include COM. I have yet to find an ex...

flyingDman

When dealing with Excel simulated keystrokes are unnecessary and unwanted. xl.close(1) saves and closes no need for ^s . There is also no need for any sleeps. There is also no need for WinActivate, ahk_class XLMAIN since we establish a unique link to excel. The 0x80010001 error pops up when you try ...

flyingDman

Try:

Code: Select all

xl := ComObjActive("excel.application")
xl.activeWorkbook.SaveCopyAs("E:\" xl.activeWorkbook.name)  ; E:\ or whatever path
xl.activeWorkbook.close(1)									; close(1) saves under current path\name then closes

flyingDman

So you want to create a hotkey (ins::) to send the option selected in the popup?. Try this: MyGui := Gui('AlwaysOnTop') MyGui.AddText(, 'Select your category') ListBox1 := MyGui.AddListBox('r6', ['Option1', 'Option2', 'Option3']) MyGui.AddButton('Default w80', 'Submit').OnEvent('Click', ButtonClicke...

flyingDman

Home:: { global ListBox1 ; <<<<<<<<<<< MyGui := Gui('AlwaysOnTop') MyGui.AddText(, "Select category") ListBox1 := MyGui.AddListBox('r6 vCategoryChoice', ['Option1', 'Option2', 'Option3', 'Option4', 'Option5', 'Option6']) MyBtn1 := MyGui.AddButton('Default w80', 'Submit').OnEvent('Click', MyBtn1_Cli...

flyingDman

Thank you for shedding light on the intrinsic ambiguity between properties and methods in VBA and your decision to discontinue this ambiguity in v2. That said, for those like me who made extensive use of the MS VBA documentation to write AHK COM code, it has not become easier as certain things that ...

flyingDman

If you are a fan of more compact code: gmax := map(), gsum := map(), res := "" for x,y in strsplit(str, "`n", "`r") { z := strsplit(y," "), grp := z[1] gmax[grp] := gmax.has(grp) ? max(gmax[grp],z[2]) : z[2] gsum[grp] := gsum.has(grp) ? gsum[grp]+z[3] : z[3] } For grp in gmax res .= grp "`t" gmax[gr...

flyingDman

My example includes one but it does not require one.

AutoHotkey Community

Search found 2832 matches

Re: loop parse "CSV" doesn't work for some CSV

Re: loop parse "CSV" doesn't work for some CSV

Re: centrer une fenêtre d'un fichier .bat au centre d'un écran sans connaitre la taille de l'écran ?

Re: loop parse "CSV" doesn't work for some CSV

Re: String Manipulation between ^ and /

Re: String Manipulation between ^ and /

Re: String Manipulation between ^ and /

Re: works in IDE, won't work “in the field”

Re: String Manipulation between ^ and /

Re: How to tell a single click from a rapid double click Topic is solved

Re: How to tell a single click from a rapid double click Topic is solved

Re: save and close Excel2010

Re: save and close Excel2010

Re: save and close Excel2010

Re: save and close Excel2010

Re: How to get a value of ListBox1 control here (conitnue)?

Re: Ho to get a value of ListBox1 control here?

Re: COM: Table Manipulation in MS Word broken in recent AHK versions

Re: Please help, Data grouping, calculating total and maximum values

Re: Combining long press and double tapping scripts