Regex to grab the text after third occurrence?

[Biraj]

Hi, I want to grab "T14 John Lewis" from "October 21 Accruals - Returns - US - T14 John Lewis - Triple".

Do you know what should be the Regex?

My Alteryx version: 2019.3.6

[Qiu]

@Biraj 
I can do better if had more data, but for now.

[binuacs · Accepted solution]

Saqueador

[Biraj]

Hi, thanks for your reply. Text to column is fine. But I kind of want to use regex here. Some other data points are:

October 21 Accruals - Marketing - US - Y284 Target - Curve
October 21 Accruals - Marketing - Asia - General - Single
October 21 Accruals - Marketing - UK - General - Single

[Biraj]

Hi,

(.+?)\-(.+?)\-(.+?)\-(.*)\-(.*)

This worked better. Is there a way to parse and not replace?

[binuacs · Accepted solution]

Changing Replace to Parse should work

Saqueador