Messages

1

General Software Discussion / Re: Looking for Standalone CSV Editor like CSVPad

« on: May 25, 2023, 10:47 PM »

CSVPad is a really decent software, and I can't believe it doesn't support the most basic thing as opening files in the command line. This also means that it does not work with file associations, which is a huge pain. Fortunately I know some AutoHotkey to make it work. Thought I'd share the code here:

Code: Autohotkey [Select]

1. ;@Ahk2Exe-SetMainIcon CSVpad.ico
2. ;@Ahk2Exe-SetDescription CLI for the simple CSV editor
3. ;@Ahk2Exe-SetVersion 1.2.0.1
4.  
5. #NoEnv
6. #NoTrayIcon
7. #SingleInstance Force
8. ListLines, Off
9. SetBatchLines -1
10. SetWorkingDir %A_ScriptDir%
11.  
12. Files := A_Args[1]
13.  
14. Run CSVpad.exe,,, PID
15. If (Files != "") {
16.     WinWait % "ahk_pid" PID
17.     DropFiles(Files, "ahk_pid" PID)
18. }
19. Return
20.  
21. DropFiles(FileList, wTitle="", Ctrl="", X=0, Y=0, NCA=0) {
22.     characterSize := A_IsUnicode ? 2 : 1
23.     fns:=RegExReplace(FileList,"\n$")
24.     fns:=RegExReplace(fns,"^\n")
25.     hDrop:=DllCall("GlobalAlloc","UInt",0x42,"UInt",20+(StrLen(fns)*characterSize)+characterSize*2)
26.  
27.     p:=DllCall("GlobalLock","UPtr",hDrop)
28.     NumPut(20, p+0)  ;offset
29.     NumPut(x,  p+4)  ;pt.x
30.     NumPut(y,  p+8)  ;pt.y
31.     NumPut(0,  p+12) ;fNC
32.     NumPut(0,  p+16) ;fWide
33.     NumPut(A_IsUnicode ? 1 : 0,  p+16) ;fWide
34.  
35.     p2:=p+20
36.     Loop,Parse,fns,`n,`r
37.     {
38.         DllCall("RtlMoveMemory","UPtr",p2,"Str",A_LoopField,"UPtr",StrLen(A_LoopField)*characterSize)
39.         p2+=StrLen(A_LoopField)*characterSize + characterSize
40.     }
41.     DllCall("GlobalUnlock","UPtr",hDrop)
42.     PostMessage, 0x233, hDrop, 0, %Ctrl%, %wTitle%
43. }