I'm not sure the sub() function is working correctly with a negative occurrence argument. Tried it in versions 12.50 and 15.10.
-}?sub("#####.000","###",",###",-1)
,#####.000
Shouldn't it return this?
##,###.000
Out of curiosity I tried this which works:
-}?sub("#####.000","#","0",-1)
####0.000
But this didn't:
-}?sub("#####.000","##","0",-1)
##0#.000
I would have expected ###0.000.
Is there an explanation or is this a bug?