I apologise for this non-Panorama query but I need help quickly to help out a friend in need.
I have a block of text which may or may not contain a number in the form #.###… where the number of decimals is unknown but is greater than two. I want to locate all such occurrences and truncate them to two decimal places. Ideally, I’d like to round them to two places but I suspect that RegEx is not up to that.
Can somebody help please.