Export MySQL query to Excel file: Difference between revisions

Export MySQL query to Excel file (edit)

119 bytes added , 31 December 2017

m

14,962

edits

@@ Line 93: / Line 93: @@
 </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. ====