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!
Advertisements
Try Out Code2care Dev Tools:

Advertisements



Android Java Linux Microsoft Google Python macOS Notepad++ Microsoft Teams CSS PHP SharePoint Html Linux C Programs Bootstrap jQuery Sublime Android Studio Facebook Eclipse WhatsApp News MySQL Json HowTos JavaScript FTP S3


Advertisements


Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and Software Developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include Learnings, Tutorials, Trouble-Shooting steps, Video Tutorials, Code Snippets, How Tos, Blogs, Articles, etc.
🎉 We are celebrating the 10th years of Code2care! Thank you for all your support! We hope we made a difference.
We strong support Gender Equality & Diversity.

We stand in solidarity with Ukraine - Make a donation to UNHCR - https://donate.unhcr.org/in/en-in/ukraine-emergency