I would like to seek advice on how to remove the zeros from a string. Basically the source I get the value from always gives 4 decimal places even if they are all zeros. So I would like to manipulate the data such that if the value is a whole number, remove the ‘.’ and ‘0’ entirely, and if there’s decimal place, remove the ‘0’ after the last sensible digit. Examples as follows: