Regex convert text to numbers
I have a property listed in a column (Device in this case) that contains a string. Somewhere inside the string is a reference to a numeric value that I need to extract and convert to an actual number. The formula below works but it seems like this could be done in a much simpler way. Regex( Substr( :Device, 6 ), "K", "000", GLOBALREPLACE )
Any instance of 1K is replaced by 1000 in this case. Slán ...