[R] remove commas in a number when reading a text file

Greg Snow Greg.Snow at imail.org
Wed Jun 15 00:00:01 CEST 2011


The following link may be of interest.  It shows a way to use gsub, but have it automatically applied while reading the data in rather than converting after:

http://finzi.psych.upenn.edu/Rhelp10/2010-February/229550.html


-- 
Gregory (Greg) L. Snow Ph.D.
Statistical Data Center
Intermountain Healthcare
greg.snow at imail.org
801.408.8111


> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-
> project.org] On Behalf Of Lee, Eric
> Sent: Monday, June 13, 2011 9:49 AM
> To: r-help at R-project.org
> Subject: [R] remove commas in a number when reading a text file
> 
> Hello,
> 
> I'm running version R x64 v2.12.2 on a 64bit windows 7 PC.  I'm trying
> to read a text file using read.table where the values have a format
> like "1,234,567".  What I want is "1234567".  Is there a quick way to
> strip out the commas?  I can use strsplit and paste, but the file is
> quite large and would take some time.  Thanks.
> 
> Eric
> 
> 	[[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.



More information about the R-help mailing list