R help - Oct 2014 - pasteFromExcel

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.

Thanks a lot.

Dan

	[[alternative HTML version deleted]]

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