Sys.exit("One or both of the input files do not exist.") If os.path.exists(sys.argv) and ('.csv'):Īscii_csv = os.path.expanduser(sys.argv) This function takes a Unicode string and encodes it to the output.
Self.encoder = codecs.getincrementalencoder(encoding)() Self.writer = csv.writer(self.queue, dialect=dialect, **kwds) This function reads and returns the next line as a Unicode string. Self.reader = csv.reader(f, dialect=dialect, **kwds) Return ().encode("utf-8")ĭef _init_(self, f, dialect=csv.excel, encoding="utf-8-sig", **kwds): Self.reader = codecs.getreader(encoding)(f) Usage: ucsv.py us-ascii-input.csv utf8_output.csv Output CSV read correctly by Numbers v3.6.1, LibreOffice Calc 5.1.2.2. Read in a US-ASCII CSV document and write out a quoted field Excel CSV. Test this on a small CSV and open it in a spreadsheet application to verify it works ok for you. Make the Python script executable in the Terminal. Otherwise, paste into a TextEdit plain text file, and save as ucvs.py.
If it is Sublime Text 3, then use Paste and Indent.
Csv to utf 8 converter code#
The output opens and formats nicely in Numbers v3.6.1, and LibreOffice Calc v5.1.2.2.Ĭopy and paste the following Python code into a programmer's editor. Here is a Python program that reads in US-ASCII CSV and outputs it as a UTF-8 quoted field, Excel compatible CSV.
0 kommentar(er)
