I am trying to reduce the number of decimals and for some reason, using a "fixed decimal" 258.2 does not change all numbers in my column to two decimal places.
Pretty much I have the following after specifying the number as a fixed decimal with 2 places:
So changing the amount of fixed decimals did not do it for me, so I have been trying to use RegEx, and came up with (^\d+.\d{2})
. This however only identifies what I want to keep.
Is there a way to do this using Regex_Replace?
Thank you all in advance for your help!
Use
^(\d+\.\d{2})\d+$
Replacement: $1
. See regex proof.
EXPLANATION
--------------------------------------------------------------------------------
^ the beginning of the string
--------------------------------------------------------------------------------
( group and capture to $1:
--------------------------------------------------------------------------------
\d+ digits (0-9) (1 or more times (matching
the most amount possible))
--------------------------------------------------------------------------------
\. '.'
--------------------------------------------------------------------------------
\d{2} digits (0-9) (2 times)
--------------------------------------------------------------------------------
) end of $1
--------------------------------------------------------------------------------
\d+ digits (0-9) (1 or more times (matching
the most amount possible))
--------------------------------------------------------------------------------
$ before an optional \n, and the end of the
string