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,
- Add Custom header and footer to Windows Notepad file
- Enabling Notepad++ Dark Theme
- Notepad++ is about to exit prompt message
- Go to Line Number option in Windows Notepad
- How to Convert CSV file to SQL Script using Notepad++
- How to un-hide tab bar in notepad++
- Notepad++ display files on tab bar as horizontal instead of vertical
- Compare two text files in Notepad++
- Column Mode Editing in Notepad++
- Convert SQL to CSV in Notepad++
- List of Programming Languages Supported by Notepad++
- Keyboard shortcut to close tab in Notepad++
- How to open a new tab in Notepad++
- How to Enable spellcheck Notepad++
- Prettify JSON in Notepad++
- Word count in Notepad++
- How to create MD5 digest in Notepad++
- Notepad++ delete lines above or below
- Unable to edit file in Notepad++
- Word wrap text in Notepad++
- Notepad++ Editor alternatives for Mac OS X
- Launch Notepad++ html document in any web browser
- Convert text to random case using Notepad++
- Show Notepad++ tabs in multiple lines instead of scroll on tab bar
- 97 Useful Notepad++ Keyboard Shortcuts
- Base 64 Encoding Decoding In Notepad++
- Where are Notepad++ temp unsaved files stored?
- How to add Date and Time to Windows Notepad File
- How to Apply Themes to Notepad++
- Multiple line editing in Notepad++
- Add comma or semicolon at end of each line Notepad++
- How to know Notepad++ is 32-bit or 64-bit Version
- Notepad++ do not show CRLF characters
- Notepad++ select all above or below lines
- Change default language highlighting in Notepad++
- How to check about details of Notepad++ text editor
- Setting up Cloud feature with Notepad++
- Add Blank Lines Between Each Lines in Notepad++
- How to zoom-in or zoom-out in Windows Notepad
- Replace tabs by spaces or comma Notepad++
- [Nopepad++] How to add text at end of each line
- Using Document Map in Notepad++
- Notepad++ insert a blank line above or below the current line example
- Portable Notepad++ for windows
- How to format or prettify XML in Notepad++
More Posts:
- Force android app to run in Landscape mode programatically - Android
- Type R is already defined error : Android Error - Android
- Call PHP function on Button click using jquery ajax - PHP
- Can't Run SDK Manager find_java.bat issue - Android
- 10 FTP SFTP Clients and Alternatives - FTP
- auth_client_using_bad_version_title : Error Android Lint - Android
- Delete file using PHP code : unlink() - PHP
- Stop android adb service from command prompt or terminal - Android
- How to add Date and Time to Windows Notepad File - NotepadPlusPlus
- Mac OS X Taking Screen Capture using Terminal - Mac-OS-X
- Create SharePoint Site Collection using PowerShell New-SPSite - SharePoint
- SharePoint workflow Canceled - Coercion Failed: Unable to transform the input lookup data into the requested type - SharePoint
- Android : Prevent App for rotation landscape or portrait - Android
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150) - MySQL
- How to change Android EditText Cursor Color - Android