I have a text field containing random notes input by users in no particular order. The text field contains two numerical values I'd like to extract and import into two fields I've created. Here's an example of what I'm working with.
Text Field: Project Description
entry 1 "Installation of 42 photovoltaic solar panels, 4.16kW capacity"
entry 2 "Installation of roof mounted solar panels (3.12kW, 20 rooftop modules)"
entry 3 "32 photovoltaic solar panels (16 of which are flush with the roof-top, remaining 16 reverse-pitch), 3.72kW capacity)
A bit of a rough example but entries are not formatted in any specific manner and my goal is to extract the kW capacity and the number of solar panels installed and import the value into two separate fields ("kW, and "#_panels")
All the values pertaining to kW capacity are double values containing two decimal places, and all values pertaining to the amount of solar panels installed are whole integers. But as you can see from entry 3, there are additional values specifying the placement of the panels.
My question, is it possible to extract these values and populate the two fields with the numerical data? I want one field containing the kW capacity, and the other field to contain the total number of solar panels.