Converting XML with Japanese characters into CSV using R

Asked Aug 14 '18 at 04:11

Active Aug 14 '18 at 08:42

Viewed 62 times

I have few XML files which are having Japanese characters, when I change it to csv it's japanese characters changed to code point e.g. <U+FA32> some characters like this. I want to keep them as it is and change it to csv or excel format. I tried changing Locale, I tried changing setting of R studio. Nothing is working. The xml contains a lot of data and some fields are having email body which consists raw data with some special characters. Let me show you how my code for changing xml to csv looks like:-

for(f in file)
{
  doc <- xmlParse(f,useInternalNodes = TRUE , fileEncoding='UTF-8');
  xL <- xmlToList(doc, fileEncoding='UTF-8');
  data <- ldply(xL, data.frame, fileEncoding='UTF-8');
  write.csv(data, concat(f,".csv"), row.names = FALSE, fileEncoding='UTF-8')

}

Please help with the solution. If we can change it to csv even with some other ways than R please help.

edited Aug 14 '18 at 08:42

Ralf Stubner

26,263
3
40
75

asked Aug 14 '18 at 04:11

KING BHAI

Is the xml file encoded in utf-8? – kennyzx Aug 14 '18 at 04:35
yes it is encoded in utf-8 – KING BHAI Aug 14 '18 at 04:49
@kennyzx can you help me? – KING BHAI Aug 14 '18 at 05:32
I don’t know R, and don’t have the xml files to figure out what is the problem. But can you try online xml to csv converters? They are free and tested. – kennyzx Aug 14 '18 at 05:40
file is big. It's size is more than 100 MB. It can't get converted. Still let me try again. – KING BHAI Aug 14 '18 at 05:54
Are you using windows? Writing UTF-8 on Windows with R is notoriously difficult. – Ralf Stubner Aug 14 '18 at 08:43
Yes I am using Windows. – KING BHAI Aug 14 '18 at 09:23
Does https://stackoverflow.com/questions/10675360/utf-8-file-output-in-r help? – Ralf Stubner Aug 14 '18 at 10:35
No it did not help – KING BHAI Aug 15 '18 at 13:24
Here some background information: http://kevinushey.github.io/blog/2018/02/21/string-encoding-and-r/. Without a sample file and a windows machine with the same locale as you (which one?), I cannot help any further, though. – Ralf Stubner Aug 17 '18 at 18:35

Converting XML with Japanese characters into CSV using R

0 Answers0