extract portion of url using regex

[Shaina1]

Hi, I have urls of the form X\Y\Z\A KPI 2021.xlsx|||B , Z\H\W\B Daily KPI 2022.xlsx|||E, D\F\C\E\G - Daily KPI 2021.xlsx|||G. I'm looking to extract A KPI, B Daily KPI, G - Daily KPI. In terms of consistency- these strings will always within the last \ and before d{4} i.e. the years expression 2021, 2022. Also-this expression would definitely contain the word KPI and sometimes also contain the word Daily, so something like (Daily|KPI) would be needed in the regex portion. Can anyone help with this ? Thanks

[flying008]

Hi, @Shaina1 

You want to like this ?

[binuacs · Accepted solution]

@Shaina1 One way of doing this

[bkurt]

[Shaina1]

Hi, thanks a lot for this ! Unfortunately, I'm still getting nulls only as my regex output. I did notice the additional dots in the expression that you have displayed. I don't need the A.KPI or B.Daily.KPI- Just need A KPI or B Daily KPI out. For now-I'm getting nulls only.

[Shaina1]

Thank you everyone ! I saw these messages later. Please discard my above message. The regex is working for me now :)