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.

Find and Replace at start of query.jpg
Step 3 : Now we need to find ); and replace with ;

Find and Replace the EOL.jpg
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.

SQL now converted to CSV format.jpg
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:
- How to create Custom RatingBar Android Programming Tutorial - Android
- How to use HashTags # correctly on Social Media Facebook Twitter - HowTos
- connection.url property value in hibernate.cfg.xml for mysql - Java
- Android AlertDialog with 3 buttons example - Android
- SQLite with Android Easy to Understand Tutorial that covers Select, Insert, Update and Delete - Android
- remove div vertical scroll - Html
- Android Display Toast on Button Click - Android
- Check Internet Connection WIFI 4G is active on Android Programmatically - Android
- Device not compatible error Android Google Play Store - Android
- [Mac] To open Eclipse you need to install the legacy java se 6 runtime - Mac-OS-X
- 86 Gmail keyboard shortcuts that you may find Advantageous - Google
- Maven Eclipse (M2e) No archetypes currently available - Java
- Tutorial: CSS Media Query for Responsive Web Design - CSS
- BSNL Broadband upgrades speed to minimum 2MBps for all users 512Kbps 1Mbps - HowTos
- ActivityManager Warning: Activity not started, its current task has been brought to the front - Android