Reg_Ex query - finding project names

[Andy_W]

Hi,

I'm trying to group together rows of data that have the same project name, while also parsing out text that appears earlier/later in the string. Essentially, I need to find the word "Project", then keep the first word after, and then trim out all text before and after. The example below should make it clearer. I suspect the Regex tool will be the answer but can't get my head around how to do it.

Any help will be greatly appreciated!

Input
Project Atlas XXX
2 Project Minerva - ZZZ
X Project Minerva AAA
Project Minerva BBBB
Project Plato - CCC
Special Project Plato - IIIII
Project Rainbow OOOO
Project Spring
XXXX Prj
ZTY

Desired Output
Project Atlas
Project Minerva
Project Minerva
Project Minerva
Project Plato
Project Plato
Project Rainbow
Project Spring
[blank]
[blank]

Cheers

[christine_assaad · Accepted solution]

Hi @Andy_W 

Please check the below screenshot. Cheers!

[Andy_W]

Hi Christine,

Thanks for the speedy reply. Unfortunately it's returning null on every row. Any idea why?

Thanks,

Andrew

[christine_assaad]

@Andy_W 

It should be (Project\s\w+). the + should come after the w for one or more word character. 

[Andy_W]

Perfect, thank you so much.