My question is : Do we have any function which can correctly format an string which is storing an amount.
Input String : '1234567'
Expected outpt : '1.234.456,00'
Input String : '1.23456.78,2586'
Expected outpt : '12.345.678,26'
Requirement is like :
there should be exectly 3 digits between consecutive '.' ','
if there are more then 2 digits after decimal point , the number should be rounded off.