Hi, I have a tempoary fix but I think there can be a better way (R way) to solve this.
If you have a unix account you can do it this way. $ vi filename For command prompt press Esc : s/\$//g Otherwise you can replace $ sign with a peculiar number say '9999' :s/\$/9999/g This substitutes $ signs with 9999 at all places and after u load the data you can replace 9999 with $ sign using regular expressions in R. There is some risk and you have to be careful to chose the peculiar number. I am not familiar with regular expressions in R either you or someone in the list can help. Regards, Kishor On Jan 2, 2008 7:05 PM, mrafi <[EMAIL PROTECTED]> wrote: > > yeah...i'd have done that but it is a 20 mb csv file...and then there are > other columns of data also..which could be distorted by this... > > r_a_mueller wrote: > > > > Am Mittwoch, 2. Januar 2008 14:14 schrieb mrafi: > >> hello respected ppl... > >> am a engg. student...i was trying to use R in statistical calculations > >> now the problem is..i imported a huge tsv file onto R...it has a column > > csv? > >> which gives cost...and it has "$" with each numerical value in this > >> column...it is something like this..$.05,$.1,$.075...and so on.. > >> R is reading it as "character vector"... > >> i tried using all the arguments but could only change it to a "factor" > >> i want to read it as numericals...and perform further operations.. > >> i know it is a stupid problem but can any1 help me get outta this... > >> thank you all...!!! > > I'd like to have it simple... open your csv-file in a text editor, with > > "find/replace" replace your "$" by "" > > > > -- > > Richard Müller - Am Spring 9 - D-58802 Balve-Eisborn > > www.oeko-sorpe.de > > > > ______________________________________________ > > R-help@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<http://www.r-project.org/posting-guide.html> > > and provide commented, minimal, self-contained, reproducible code. > > > > > > -- > View this message in context: > http://www.nabble.com/how-to-ignore-or-omit-somethings-while-reading-the-data-table-tp14578131p14578428.html > Sent from the R help mailing list archive at Nabble.com<http://nabble.com/> > . > > ______________________________________________ > R-help@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<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. > [[alternative HTML version deleted]]
______________________________________________ R-help@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.
