To the List;
I replied privately with a screenshot and an .xlsx worked example since it
seemed the major issue was how Excel handled currency formatting for character
strings created n R, ... not really an on-topic subject matter for this list. I
know Dan also reads the R-SIG-Insurance list and
Sure, that is one pattern to try to detect, but there are many more
(e.g., cannot have multiple '$' or '€'). For speed, I'm looking for a
*single* expression to detect valid currency strings in one grep.
The one shown for US works. For euros, it might suffice to replace '$'
with '€' but I cannot t
On Oct 20, 2014, at 2:34 PM, Dan Murphy wrote:
> Good ideas, David.
>
> 1) By "confirm that MS Excel honors that OutDec" I mean that, in a
> location (France? others?) where options("OutDec") is a comma, does MS
> Excel format numbers that way when displaying currencies with decimal
> places? I
Good ideas, David.
1) By "confirm that MS Excel honors that OutDec" I mean that, in a
location (France? others?) where options("OutDec") is a comma, does MS
Excel format numbers that way when displaying currencies with decimal
places? I have no way of knowing if that is true in all OutDec = ","
lo
On Oct 20, 2014, at 10:29 AM, Dan Murphy wrote:
> 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 OutDe
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, Dav
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 fro
7 matches
Mail list logo
