Geek Answers Handbook

Openoffice - CSV-export: is there an escape-charcter by default?

As far as I can see OpenOffice, when it comes to saving the file as a csv file, it includes all lines in character-characters.

So, is there a need for an escape character?

and related to this question:

Does OpenOffice have a default escape character?

+5
source share
3 answers

Reset in quotation marks makes life easier for tools that parse the CSV file.

+3
source

, escape- OpenOffice csv. phpmyadmin 9000 50+, .ods, , , escape- CSV.

, csv, find/replace, escape- \(back slash). , , phpmyadmin .

\(back-slash), , :

  • -, . 'abcdefg', csv.
  • / "" ( ) . .
  • / "( , , ), \" ( ). / "" ", " \ "\" ". , .
  • / - \"" ( ).

, , .ods .xlsx csv ( , ).

+4

LibreOffice (3.4.4) CSV phpMyAdmin. LibreOffice escape-, "CSV" phpMyAdmin ", ": . .

However, using the CSV option using LOAD DATA really only worked if the value in the Column escaped with was deleted . I assume that phpMyAdmin uses the MySQL LOAD DATA command by default, and thus the control is passed to MySQL to process the data. In my scenario, this led to accurate data import.

0
source

More articles:


All Articles