Replace tabs by spaces or comma Notepad++


At times you may have a file ( mostly tab-separated values files like CSV files) which you want to edit to replace the tab separations by spaces or (,) comma.

You can do so using Text Editors like notepad++ using Find and Replace option using regular expressions.

How-to-do-it Steps:

  1. Open the file in Notepad++
  2. All tabs are replaced by spaces.png
    All tabs are replaced by spaces.png
  3. Press Ctrl + F to open Find Box. Select Replace tab. Add /t to Find what field and a space or a comma (,) as per what's your need to the Replace with filed.
  4. Replace tabs with spaces or commas notepad++.png
    Replace tabs with spaces or commas notepad++.png
  5. Click on Replace All. All tabs will be replaced by spaces/comma's.
Tab separated file opened in Notepad++.png
Tab separated file opened in Notepad++.png

?? Remember to set the Search Mode to Extended (\n \r \t \0 \x ..) or else you would not get desired results!


Comments:

  • Aggh! Images makes it easy to understand, thank you for the examples - makes it really easy to understand!
    anon14 11 Sep 2020 11:01:21 GMT
  • Further comments disabled!