On Oct 19, 2014, at 11:18 PM, Dan Murphy wrote: > To Users of Excel: > > Following advice from Brian and Markus, I created an RMarkdown "vignette" > that shows an example of how the pasteFromExcel function in the excelRio > package on github could be used by an actuary to transfer a triangle from > Excel to R. See today's post at http://trinostics.blogspot.com/ > > Unfortunately, if you are located outside the US, the demonstrated > functionality will not work for you because the currency regex implemented > assumes the dollar sign ($) and comma/decimal punctuation of the form > 999,999.00. > > If anyone is interested in contributing currency regex expressions that > work in your locale, I would be happy to try to incorporate them in the > package. If anyone knows how best to determine the user's locale (might > "timezone" suffice?), I'd appreciate that help too. >
?Sys.getlocale # perhaps "LC_MONETARY" ?options # look for OutDec > [[alternative HTML version deleted]] David Winsemius Alameda, CA, USA ______________________________________________ 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.
