983 reputation
58
bio website
location Front Royal, VA
age 33
visits member for 4 years, 5 months
seen Dec 24 at 18:24

Sep
24
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
Hey @HPM, any chance of getting to work on your data?
Sep
23
answered Comparing 2 columns to result in a count total
Sep
20
comment Generate a comma-separated list of cell contents, excluding blanks
@iszi, just how many blank cells are you dealing with? The nesting is only required if you want to handle a lot. If you don't want nested anything, you're going to need a user-defined formula.
Sep
20
comment Generate a comma-separated list of cell contents, excluding blanks
SUBSTITUTE does replace all matches. 398 (24 * 16 + 14) commas get reduced to 38 commas, 38 (4 * 8 + 6) to 10, 10 (2 * 4 + 2) to 4, 4 (1 * 3 + 1) to 2, and 2 to 1.
Sep
20
answered Generate a comma-separated list of cell contents, excluding blanks
Sep
20
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
Is the data sensitive? Or could you share it on Dropbox/Google-Drive/etc.? If Notepad++ can open and handle that file, I would imagine that my solution would work, but I'd love to try it out myself.
Sep
19
revised How can I sort the lines in a text file, by the length of each line, in Notepad++?
Added an explanation for how this works as well as sample data.
Sep
19
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
Sure. I'll add one too now, but feel free to improve it.
Sep
18
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
@barlop I'll see if I can do a little diagnosis on the N++ macro. The result from my simple attempt was terribly corrupted results with many unusual and non-printing characters added. Also, while I was inspired by the YouTube video, my steps are a bit different.
Sep
16
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
The answer has been updated to retain the existing sort order, assuming that is important.
Sep
16
revised How can I sort the lines in a text file, by the length of each line, in Notepad++?
added 703 characters in body
Sep
16
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
@Bob is correct, if you have lines of a given length, such as 33 characters, that have a particular order to them, that will not be reflected in the results. We can add the line numbers with Alt+C prior to step 1 (including leading 0s to ensure that lengths remain equal). Then, when cleaning up in step 4, use ^ *\d{5} or whatever number of digits were used for the line numbers.
Sep
16
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
@Bob: no good. The lowercase thing is even mentioned in the release notes for the SQL in N++ plug-in.
Sep
16
answered How can I sort the lines in a text file, by the length of each line, in Notepad++?
Sep
16
comment How can I sort the lines in a text file, by the length of each line, in Notepad++?
This is actually a great solution, if only SQL in N++ didn't mangle the data output. I just tested out your solution, and I added delimiters to the end of all lines with a quick regex replace, but the data output converts everything to lowercase, and replaced my dashes with question marks.
Sep
10
comment Hacker Typer style application for Windows
Ooh, hey, @Kaivosukeltaja, I updated my script before I saw your comment and acceptance. The updated script has a GUI and a few improvements (especially the "SendMode InputThenPlay"). I have a line in the format of a:: for every key I want to remap. It may be as simple as adding a couple lines with the additional keys on your keyboard.
Sep
10
revised Hacker Typer style application for Windows
Improved my script with a GUI.
Sep
10
revised Hacker Typer style application for Windows
added 824 characters in body
Sep
10
revised Hacker Typer style application for Windows
added 824 characters in body
Sep
10
comment Hacker Typer style application for Windows
Are you looking for someone to write the AutoHotKey script for you?