Extract a text

[sghafour]

May I kindly ask you to help me how I can extract a specific word (containing CF) from the field "Subject" and then have it in column "CF number" like the attached screenshot?

Subject	CF Number
Something CF4173 - P45464	CF4173
Test - CF4171 - P24	CF4171
EMEA - 10000802 - CF4172	CF4172
EMEA PO Policy Exception  CF4176  P25257152N	CF4176
064 (CF4019)	CF4019
(CF4018)	CF4018

Thank you very much in advance.

[Deano478 · Accepted solution]

hey @sghafour use the regex tool in parse mode with the following expresssion:

.*?(CF\d+).*?

[sghafour]

Great , thank you very much