How can I create a new var(var2) extracting part of string from var1 with varying length?
The string portion that I want to extract is between "evb_" and "_f" and are in the next table (var2):
| var1 | var2 |
| axb_bk_evb_0300_f_9 | 0300 |
| axb_bk_evb_1000_f_5 | 1000 |
| axb_bk_evb_4500_f | 4500 |
| axb_bk_evb_1700_f | 1700 |
| axb_bk_evb_0600_f | 0600 |
| axb_bk_evb_1200_f_3 | 1200 |
| axb_bk_evb_1100_f | 1100 |
| axb_bk_evb_1300_f_4 | 1300 |
| axb_bk_evb_2500_f | 2500 |
Kind Regards.
R.
0 Response to create a new var extracting part of string with varying length
Post a Comment