Venkata Kirankumar
2014-Feb-04 15:58 UTC
[R] Handling special characters in reading and writing to CSV
Hi All, I have some data with different special characters, newline character, and different language characters in a CSV file like `~!@#$%^&*| ()-_+={[}]|\:;""'<,>.?/ in data, while I am trying to read this CSV and trying to do calculations I am not able to get this data as there in single cell. I found something like RFC 4180 format can help to solve this problem. If anyone can give suggestion related to handling these special characters it will be help full for me Thanks in advance, D V Kiran Kumar [[alternative HTML version deleted]]
David Winsemius
2014-Feb-04 21:44 UTC
[R] Handling special characters in reading and writing to CSV
On Feb 4, 2014, at 7:58 AM, Venkata Kirankumar wrote:> Hi All, > > > I have some data with different special characters, newline character, and > different language characters in a CSV file like `~!@#$%^&*| > ()-_+={[}]|\:;""'<,>.?/ > in data, while I am trying to read this CSV and trying to do calculations I > am not able to get this data as there in single cell. I found something > like RFC 4180 format can help to solve this problem. > > > > If anyone can give suggestion related to handling these special characters > it will be help full for me >I'm having a difficult time understanding your expectations and thedata situation. If it's a "csv file", then how can all three of <comma>, <single-quote>, and <double-quote> be properly distinguished when they are also part of the data? You might consider using readLines (from base) or read.fwf (from the utils package)> > > Thanks in advance, > > D V Kiran Kumar > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.David Winsemius Alameda, CA, USA