Skip to content

Page 27

Notepad++ Macros Example

Notepad++ logo.

Do you ever find yourself doing the same things over and over and over again when working on your text files? You can save a lot of time by recording and running Notepad++ macros to automate these repetitive steps. Just record your steps once, then run them as many times as you need!

Animation showing how to record and run Notepad++ macros.

A shy first-timer at PASS Summit 2013

PASS Summit 2013 Logo.

It’s not easy to write about PASS Summit 2013 in a structured way. Just like the summit was buzzing with energy I feel like running around tossing keywords and hashtags at people: #SQLFamily! Ribbons! First timers! Sessions! #SQLKaraoke! Exhibitor booths! It was all a little overwhelming for this shy first-timer, but also exciting and fun at the same time.

Notepad++ Remove Duplicates, Remove Blank Lines, and Sort Data in One Operation

Notepad++ logo.

You can use the 32-bit version of Notepad++ with the TextFX plugin to quickly remove duplicates, remove blank lines, and sort data - in one operation! This is a fast and easy way to get the results you want in just a few seconds. And as with any kind of automation: the more data you work with, the more time you save 🤓

Animation showing how to remove duplicates, remove blank lines, and sorting data in Notepad++.

The quick version:

  • Install the 32-bit version of Notepad++
  • Install the TextFX plugin (this is not available in the 64-bit version of Notepad++)
  • Enable Sort outputs only UNIQUE
  • Click Sort lines case [in]sensitive

Takeoff! Launching cathrinewilhelmsen.net

Large pink fireworks exploding.

Today, I will be marking my calendar with a bright color. (Probably pink.) I’m taking a plunge into the world known as “The Internet” and launching cathrinewilhelmsen.net! It’s quite exciting to have my own little place online 🤓

I have a few reasons for launching cathrinewilhelmsen.net. The first reason is entirely selfish: I want to tell everyone hi, hello, my name is Cathrine, this is who I am and this is what I like to do. The second reason is because I want a place where I can learn and experiment with web design and web development. And the third reason is that I want to keep a tiny library of useful links and code snippets and tips and tricks.

I have no idea yet what this website will grow into, but I’m excited! Welcome to cathrinewilhelmsen.net, I’m happy to have you here 🥳

About Cathrine

Cathrine Wilhelmsen smiling.

Hi! I’m Cathrine. I love data and coding, as well as teaching and sharing knowledge 🤓

When I was 10 years old, I decided to learn HTML and CSS because it was fun! That curiosity and passion for solving technical challenges has stuck with me ever since.

I’ve now worked with Azure Data and the Microsoft Data Platform for over 15 years, mainly focusing on Business Intelligence, Data Integration and Data Warehousing projects. My core skills are Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, Power BI, and T-SQL development, but I enjoy everything from programming to data visualization.

Badge showing that Cathrine Wilhelmsen is a Microsoft Most Valuable Professional (MVP)

Outside of work, I’m an international speaker, author, blogger, organizer, and chronic volunteer. Because of my community involvement, I have received the Microsoft Data Platform MVP Award every year since 2015.

I’m also a Microsoft Certified: Fabric Data Engineer Associate, a Microsoft Certified Fabric Analytics Engineer Associate, and I’m old enough to still be a proud Microsoft Certified: Azure Data Engineer Associate and Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics.

…yeah, there’s a reason I call myself a full-time geek. I also love sci-fi and fantasy, design and typography, coffee and chocolate, I’m a dog mom and cat lover, and you will never take my emojis from me! (I made custom 8x8 pixel smilies to use on my first blog back in 2001, I’m allowed to enjoy the emoji keyboard in Windows 😁)

Find me!