Extracting constant text and variating numbers from column

[Vmgh]

Hi All, 

I have a column with around 100 rows as the ones below. I would like to remove all characters except CPM along with the underscore and the 3 following numbers (CPM_XXX). I have tried to look around and found ways to get the CPM from each field... Unfortunately i can't find a way to get the variating numbers included. Any suggestions? 

OnePager CPM_527 G1 rinsing.pptx
OnePager CPM_529 G1 Holding Time.pptx
OnePager CPM_531 G1 washing.pptx
CPM_294 calculation.pptx
CPM_530 Grade.pptx
CPM_233 runs.pptx
CPM_273 Cleaning One Pager.pptx
CPM_283 Guidance.pptx

[LordNeilLord · Accepted solution]

Hey @Vmgh 

With the regex tool (in parse mode) use the expression: (CPM_\d{3}) which means find CPM_ then 3 numbers

[Vmgh]

Thank you very much!