Hi there,
I have column where values are like below table. I want trim this value such a way before gp- and after _2023 characters will get eliminated and i will get below output data. these are just sample values i have many records with such scenarios but condition is same for all. Can anyone please help me on this.
| Barbados-capital-investments-gp-growth-plan-series-i_2023_06_30_fund-performance-report |
| Barbados-capital-investments-gp-growth-plan-series-ii_2023_06_30_fund-performance-report |
Output data
| growth-plan-series-i |
| growth-plan-series-ii |
