Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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