Processing
 

write.csv with encoding UTF8

29/08/2016 09:10#1

Sunday

Member

Joined at: 4 months ago

Post: 1

Thank: 0

Thanked: 0

I am using Windows7 Home Premium and R Studio 0.99.896. I have a csv file containing a column with text in several different languages eg english, european, korean, simplified chinese, traditional chinese, greek, japanese etc.

I read it into R using

table<-read.csv("broker.csv",stringsAsFactors =F, encoding="UTF-8")

so that all the text is readable in it's language.

Most of the text is within a column called named "content". Within the console, when I have a look

toplines<-head(table$content,10)

I can see all the languages as they are, but when I try to write to a csv file and open it in excel, I can no longer see the languages. I typed in

write.csv(toplines,file="toplines.csv",fileEncoding="UTF-8")

then I opened toplines.csv in excel 2013 and it looked liked this

1   [<U+5916><U+5A92>:<U+4E2D><U+56FD><U+6C1..... 2   [<U+4E2D><U+56FD><U+6C11><U+822A><U+51C6..... 3   [<U+5916><U+5A92>:<U+4E2D><U+56FD><U+6C1..... 

and so forth

Would anyone be able to tell me how I can write to a csv or excel file so that the languages that can be read as they are in Excel 2013? Thank you very much.

Similar articles

Excel More conditions in one formula?

4 months ago - Reply: 2 - Views: 171

Get Workbook reference from Open File dialog

4 months ago - Reply: 2 - Views: 128

Add Calculated Field To Pivot Table

4 months ago - Reply: 0 - Views: 5

Nested IF Functions in Excel not working

4 months ago - Reply: 3 - Views: 163

Formulating Date in Excel 2013

5 months ago - Reply: 2 - Views: 88

VB6 extracts in Excel 2013

5 months ago - Reply: 2 - Views: 153

Excel 2013 : Pull Matching Data from Column

5 months ago - Reply: 1 - Views: 19

excel search and copy in/from another file

5 months ago - Reply: 0 - Views: 1

Buggy PivotTable.ColumnRange

5 months ago - Reply: 0 - Views: 4

Excel static conditional formatting area

5 months ago - Reply: 0 - Views: 8

vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re vé máy bay vé máy bay giá rẻ ve may bay ve may bay gia re