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)

Leave a Reply