r - write.csv with encoding UTF8 -


i using windows7 home premium , r studio 0.99.896. have csv file containing column text in several different languages eg english, european, korean, simplified chinese, traditional chinese, greek, japanese etc.

i read r using

table<-read.csv("broker.csv",stringsasfactors =f, encoding="utf-8")

so text readable in it's language.

most of text within column called named "content". within console, when have look

toplines<-head(table$content,10)

i can see languages are, when try write csv file , open in excel, can no longer see languages. typed in

write.csv(toplines,file="toplines.csv",fileencoding="utf-8")

then opened toplines.csv in excel 2013 , 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 forth

would able tell me how can write csv or excel file languages can read in excel 2013? thank much.


Comments

Popular posts from this blog

amazon web services - S3 Pre-signed POST validate file type? -

c# - Check Keyboard Input Winforms -