How to Change a Saved Twitter Stream to Chronological Order

If you’ve ever tried to transcribe a Twitter chat or conversation thread around a particular keyword or hash tag, you know that converting the chain to chronological order can be a real hassle. Whether you copy and paste a thread from Twitter search or a chat-hosting service like Twebevent, the default presentation is reverse-chronological, with the most recent posts at the top and the earliest at the bottom. Using Word, the only way to change the order to chronological is by methodically cutting and pasting posts into a new document. Ugh.

I’ve discovered a way to automate this conversion using one of my favorite tools: the open source Notepad++. Here’s how you do it:

  1. Copy and paste the thread into Notepad++
  2. Select all text and choose TextFX|TextFX Tools|Insert Line Numbers.
  3. With text still selected, choose TextFX|TextFX Tools|+ Sort ascending and remove the check mark
  4. With text still selected, choose TextFX|TextFX Tools|Sort lines case insensitive (at column). This sorts the lines by number in descending order.
  5. With text still selected, choose TextFX|TextFX Tools|Delete Line Numbers or First Word.

You’re done!

You can also use Notepad++’s lightning-fast search and replace feature to pretty up the formatting. For example, search for “@pgillin” and replace it with “<strong>@pgillin:</strong”> to bold-face the name of a contributor to the conversation. Or replace hash tags like “#sm” with “social media” to make the conversation accessible to the uninitiated.

Because Notepad++ is a text editor and not a word processor, it removes all formatting from any document you cut and paste into it. However, this shouldn’t be a problem with Twitter chats because Twitter doesn’t support formatting itself. If you know a little HTML, you can always add back the formatting with Notepad++’s search/replace function.

2 thoughts on “How to Change a Saved Twitter Stream to Chronological Order

  1. Hello!

    Just wanted to thank you for sharing this information. I am a regular Twitter user but I’ve never tried to organize them in chronological order before but after reading your article I will definitely try to do that! Thanks a lot again!

  2. I’ve been hunting high and low for a solution to this so thank you so very much for your post.

    I have downloaded Notepad++, copied, pasted and selected the text but I am struggling to locate the TextFX|TextFX Tools|Insert Line Numbers options… where should I be looking?

Leave a Reply

Your email address will not be published. Required fields are marked *