The incentive has a maximum of $6000.00, The incentive has a maximum of 5.00 Years |
The incentive is 0.48 $/kWh |
The incentive is 0.60 $/W, The system size has a minimum of 150.00 kW, The system size has a maximum of 200.00 kW |
The incentive is 100.00 % |
The incentive is 25.00 %, The incentive has a maximum of $1000.00 |
The system size has a maximum of 50.00 kW, The incentive is 1.05 $/W |
What I want to do is extract, for example, if there is a section of the string that contains "The incentive is (NUMBER I WANT TO EXTRACT) $/kWh", I want to extract that number and generate a new variable with it.
So for example, for the sample data above, I want the following output
The incentive has a maximum of $6000.00, The incentive has a maximum of 5.00 Years | . |
The incentive is 0.48 $/kWh | 0.48 |
The incentive is 0.60 $/W, The system size has a minimum of 150.00 kW, The system size has a maximum of 200.00 kW | 0.60 |
The incentive is 100.00 % | . |
The incentive is 25.00 %, The incentive has a maximum of $1000.00 | . |
The system size has a maximum of 50.00 kW, The incentive is 1.05 $/W | . |
I've read string help, but I'm still struggling with this code.
Thank you so much for all the help in advance.
0 Response to Extracting a specific part of a string if the string contains an exact syntax
Post a Comment