| 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