Categories
Uncategorized

Basic Data Cleaning With Sublime

Remove Duplicate

Highlight the line of data, then, you can go to Edit > Permute Lines > Unique.

Remove Blank/Empty Line

  • Select the Test
  • Press Ctrl + H on PC, or Command + Alt + F on Mac or Click Find->Replace.
  • Make sure you have selected ‘regular expression’ by pressing:
    • Alt + R on PC or Command + Alt + R on Mac or Click .* in the Find box.
  • Find what: ^\n
  • Replace With: (nothing, leave in blank)

https://stackoverflow.com/questions/12008986/sublime-text-2-how-to-delete-blank-empty-lines#answer-12009505

Leave a Reply