Export MySQL query to Excel file: Difference between revisions

Jump to navigation Jump to search
m
Line 93: Line 93:
</pre>
</pre>


validation: Use the editor supported [[Regular expression]], search {{kbd | key=<nowiki>^[^"]</nowiki>}} in the csv files to search the rows which contains return symbols.
Validation: Use the editor supported [[Regular expression]],  
* Search {{kbd | key=<nowiki>^[^"]</nowiki>}} in the csv files to search the rows which contains return symbols. The {{kbd | key=<nowiki>"</nowiki>}} symbol is the "text qualifier" what I specified before export the MySQL query.


==== Step 2: Convert CSV to XLSX/XLS file format. ====
==== Step 2: Convert CSV to XLSX/XLS file format. ====

Navigation menu