Brief: Blank line removal and separating comma-separated list in Notepad++

[20190205 note: Registration is available for Analytics>Forward 2019 (LINK)! I think registrations are trending higher than last year so selling-out is a risk.]

I received a list of numbers in Excel and needed to:

  •  Eliminate the blank lines
  • Where values separated by a comma like “1323290, 4324432187” appeared, make each value appear on its own row, sans a comma a la:
    • 1323290
    • 4324432187

Solution in Notepad++:

  • Eliminate the blank lines by “Remove Empty Lines” under Edit -> Line Operations ->
  • Press CTRL+H to open the Replace menu box. Press CTRL+X to choose Extended as the Search Mode at the bottom-left.
  • Next to “Find what :”, press the comma-key and then the space-key inside the box
  • Next to “Replace with :”, place \n inside the box
  • Press CTRL+A to Replace All

1_clearempty.png2_before

3_end

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s