Hello again, I my day to day calculation, I need to take lot of data from Excel and forth and generally I use 'clipboard' option with read.delim() function. However many time, the data in Excel are like '(111,000)' instead of '-111000'. Generally I convert data in the 2nd form in Excel itself and then copy to clipboard. Is there any option in R, so that I can copy-paste '(111,000)' directly into R in numeric format? And also pasting data into Clipboard from R in the format of '(111,000)'? Thanks for your input
Copy data from Excel
3 messages · Christofer Bogaso, David Winsemius, jim holtman
On Dec 19, 2012, at 10:22 AM, Christofer Bogaso wrote:
Hello again, I my day to day calculation, I need to take lot of data from Excel and forth and generally I use 'clipboard' option with read.delim() function. However many time, the data in Excel are like '(111,000)' instead of '-111000'. Generally I convert data in the 2nd form in Excel itself and then copy to clipboard. Is there any option in R, so that I can copy-paste '(111,000)' directly into R in numeric format? And also pasting data into Clipboard from R in the format of '(111,000)'?
If you read from the clipboard with one of the `read.*` functions after defining an Audit class and an `as.Audit` function and include colClasses=c( ..., Audit, ...) in the appropriate location you would be able to get automatic conversions. There are examples of this in the Rhelp Archives.
David Winsemius Alameda, CA, USA
If you are going to be reading a lot of data from EXCEL, use the XLConnect package since it will give you back the values as numeric instead of the "formatted" values with commas. Also it means you can automate the activity since you don't have to use the "clipboard". On Wed, Dec 19, 2012 at 1:22 PM, Christofer Bogaso
<bogaso.christofer at gmail.com> wrote:
Hello again, I my day to day calculation, I need to take lot of data from Excel and forth and generally I use 'clipboard' option with read.delim() function. However many time, the data in Excel are like '(111,000)' instead of '-111000'. Generally I convert data in the 2nd form in Excel itself and then copy to clipboard. Is there any option in R, so that I can copy-paste '(111,000)' directly into R in numeric format? And also pasting data into Clipboard from R in the format of '(111,000)'? Thanks for your input
______________________________________________ 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.
Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it.