Notice that I am making use of the keys End and Home for navigating through the line (pressing twice for wrapped lines). With these observations, we are ready to record our macro. The Entry#9, Dil Bechara, does not have a gross value.It's the last word of the line where the first and the last characters are to be cleaned from it ($, M). The gross value is in the 11th line of the entry, along with some other data.The movie's name is in the 2nd line of the entry, plain.In this case, I do the following observations: For that, we need to realize a pattern between the movie name and the gross value we want to extract. Now, we will record the macro that extracts the movie name and gross value from each entry. We copy the text from the web page to Notepad++. Our task is to clean it from them and also match this value with the movie name in a nice format. The gross value is listed in the IMDb site with a dollar sign at the beginning and M letter at the end. We're keeping the number small for demonstration purposes. Let's say we want to sort the first 10 movies in IMDb top-rated list according to their gross income. However, if you're one of those (just like myself) who struggle to even exit from Vim, then this method might come handy. If you're a Vim or Emacs user, you're probably familiar with using macros for this type of stuff. For this kind of one-time tasks, I think writing a script takes more time than the method I'm going to describe in this post! Or simply, you want to change the format of a CSV file quickly.

Let's say you want to sort some data you found online, dirtily embedded in a webpage.

Notepad ++ sort by last character