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:
- Open the file in Notepad++
- 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.
- Click on Replace All. All tabs will be replaced by spaces/comma's.

All tabs are replaced by spaces.png

Replace tabs with spaces or commas 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!
More Posts related to NotepadPlusPlus,
- [Solution] Notepad++ Compare option unavailable
- How to delete all text after a character or string in Notepad++
- Notepad++ hex editor Examples
- Add Custom header and footer to Windows Notepad file
- Unable to edit file in Notepad++
- Locate Notepad++ unsaved files backup location
- Add Text at Start and End of Each Line Notepad++
- [Tutorial] How to Customize Notepad++ Toolbar
- How to hide lines in Notepad++
- How to close all tabs of Notepad++?
- Notepad++ Save Failed - Please check if this file is opened in another program.
- How to connect to an FTP or SFTP location using Notepad++
- How to add or remove bookmark on a line in Notepad++
- Enabling Notepad++ Dark Theme
- Notepad++ Reload - This file has been modified by another program. Do you want to reload it?
- Prettify JSON in Notepad++
- Portable Notepad++ for windows
- Alternatives for Notepad++ on Mac in 2021
- Indent XML Formatting In Notepad++
- Go to Line Number option in Windows Notepad
- Word count in Notepad++
- Show Notepad++ tabs in multiple lines instead of scroll on tab bar
- [Nopepad++] How to add text at end of each line
- How to open a new tab in Notepad++
- How to open Notepad?
More Posts:
- How to activate and use Microsoft Teams Together mode - Microsoft
- List of 32 CSS cursors web developers must know about - CSS
- List of jars required for Struts2 project - Java
- How to uninstall pip Python packages - Python
- Run Java Code Every Second - Java
- How to copy file name and path to clipboard in Notepad++ - NotepadPlusPlus
- [Solved] SharePoint Search Internal server error exception - SharePoint
- hibernate.cfg.xml Configuration and Mapping xml Example - Java