SQL Script can be converted to CSV format using Notepad++ Editor using few simple steps using Find and Replace option. As no regular expressions are to be used, we can achieve this even with editors that do not have them.
Let's take a sample SQL script,insert into my_sql_table (id,name,marks) values ('1','Joe','66');
insert into my_sql_table (id,name,marks) values ('2','Mark','45');
insert into my_sql_table (id,name,marks) values ('3','Steve','23');
insert into my_sql_table (id,name,marks) values ('4','Larry','57');
insert into my_sql_table (id,name,marks) values ('5','Smith','78');
Steps to Convert SQL Script to CSV Format
Step 1 : Copy the fields values to a separate tab.
Step 2: Press Ctrl + F to open find and replace dialog, and move to replace the tag, see to it that search mode is Normal. Now Find insert into my_sql_table (id,name,marks) values ( and replace with Blank.

Step 3 : Now we need to find ); and replace with ;

Step 4: Now we have our CSV format almost ready, just copy the Step 1: copied Table fields at the top of the file, the result is CSV.

- Notepad++ Editor alternatives for macOS
- How to add or remove bookmark on a line in Notepad++
- Notepad++ do not show CRLF characters
- Reduce the size of Tabs on Notepad++
- Delete blank lines in a file using Notepad++
- Fix: Notepad++ bottom status bar not visible
- Notepad++ Hex Editor
- How to show End of Line Characters in File using Notepad++
- [Tutorial] Write And Run Python Code In Notepad++ Editor
- How to install XML Tools Plugin Notepad++
- Customizing Notepad++ New Document Line Encoding: CR/LF/CR LF
- How to remove blank lines from a file using Notepad++
- Column Mode Editing in Notepad++
- Convert text to random case using Notepad++
- How to recover unsaved notepad file Windows 10
- How to delete all text after a character or string in Notepad++
- Setting up Cloud feature with Notepad++
- Install Notepad++ silently using Windows Powershell
- Using Document Map in Notepad++
- Enabling Notepad++ Dark Theme
- [Fix] Notepad++ tab not visible (hidden)
- Where are Notepad++ macros stored?
- Multiple line editing in Notepad++
- Alternatives for Notepad++ on Mac in 2021
- [Nopepad++] How to add text at end of each line
- That did'nt work, Issue type User not in directory - SharePoint external access error - SharePoint
- CSS: Apply opacity only for div background and not text - CSS
- Save current timestamp in MySQL using PHP mysqi binding - PHP
- SharePoint PowerShell Merge-SPLogFile filter by time using StartTime EndTime - SharePoint
- How choose alternate Tab Bar icon in Notepad++ - NotepadPlusPlus
- Detect Data roaming in Android Application - Android
- How to find the Battery Cycle Count on macOS Ventura - MacOS
- How to destroy PHP session() - PHP