I have? a file, containing a dump of MySQL database. It was intended to fill existing MySQL database at? server (it contains data only for one table of the database).
It contains strings like:
"INSERT INTO paddata VALUES (..." and many values are insereted into fields of the table.
I need to extract and save to? 3? separate files line-by-line? fields? #4 ,? #20 and # 21 of this database.
The file is more than 20 MB (more than 15,000 lines) so the task? cannot be? performed manually. You can create? a database, fill it with this data and then read required? fields from there and write them to separate files line-by-line. Or you can do something else, if you have ideas on that.
I attach sample file, that contains? first 5 lines of the original one. I open it in Notepad++, as in usual notepad the structure of lines is not visible.