regex for copy pasted mysql table data

Question

How could I format this so it fits a csv format? I accidentally deleted my table and now I need to export this data.

+-----+---------------------------------+-------------+-------------------+
| id  | email                           | firstName   | lastName          |
+-----+---------------------------------+-------------+-------------------+
|   6 | email@email.com                 | Person1     | Person1           |
|   7 | email2@email.com                | Person2     | Person2           |
|   8 | email3@email.com                | Person3     | Person3           |
+-----+---------------------------------+-------------+-------------------+

This is a text file I made before, so how could I remove the lines so that it goes like:

"6","email@email.com","Person1","Person1"

Answer 1

You can do it manually in Excel (open file, Data -> Text to Columns, Fixed width.

Regex-wise, 2 options:

• replace stuff:

  s/^|s+/"/;
  s/s+|s+/","/g;
  s/s*|$/"/;
  

• match stuff:

  s/^|s+(d+)s+|s+(S+)s+|s+(S+)s+|s+(S+)s+|$/"$1","$2","$3,"$4"/
  

Of course, the exact syntax depends on the language you use.