Nice. So if someone were to offer a currency regular expression that works in their locale, I should also ask them to give me the results of Sys.getlocale("LC_MONETARY") and options("OutDec") and confirm that MS Excel honors that OutDec. Thank you, David. -Dan
On Mon, Oct 20, 2014 at 10:04 AM, David Winsemius <dwinsem...@comcast.net> wrote: > > 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.