Hi R users, I have a string for example 'X35.84375_.100.71875', and I have another dataframe df that I want to export with the transformed string name '35.84375_-100.71875' with no extension. How to do this in R? Thanks for your help. a = 'X35.84375_.100.71875' write.table(df, file='', row.names=F, col.names=F) [[alternative HTML version deleted]]
just strip off the first character:> a[1] "X35.84375_.100.71875"> a.new <- sub("^.", '', a) > a.new[1] "35.84375_.100.71875">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. On Thu, Jul 28, 2016 at 3:51 PM, lily li <chocold12 at gmail.com> wrote:> Hi R users, > > I have a string for example 'X35.84375_.100.71875', and I have another > dataframe df that I want to export with the transformed string name > '35.84375_-100.71875' with no extension. How to do this in R? Thanks for > your help. > > a = 'X35.84375_.100.71875' > write.table(df, file='', row.names=F, col.names=F) > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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. >[[alternative HTML version deleted]]
Thanks, but how to get the string like this: "35.84375_-100.71875" use the minus sign instead of dot. On Thu, Jul 28, 2016 at 2:38 PM, jim holtman <jholtman at gmail.com> wrote:> just strip off the first character: > > > a > [1] "X35.84375_.100.71875" > > a.new <- sub("^.", '', a) > > a.new > [1] "35.84375_.100.71875" > > > > > 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. > > On Thu, Jul 28, 2016 at 3:51 PM, lily li <chocold12 at gmail.com> wrote: > >> Hi R users, >> >> I have a string for example 'X35.84375_.100.71875', and I have another >> dataframe df that I want to export with the transformed string name >> '35.84375_-100.71875' with no extension. How to do this in R? Thanks for >> your help. >> >> a = 'X35.84375_.100.71875' >> write.table(df, file='', row.names=F, col.names=F) >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >> 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. >> > >[[alternative HTML version deleted]]