I will be receiving CSV's with a lot of info in each cell but I need the first number that appears in the cell. Is there a way to extract the first number automatically without having to select each one manually? Here's an example...

Here I would need the number 147.23
josh;smith;147.23;2;0;371;