Extracting data based on a set criteria

[Mamamia]

Hi,

I'm trying to extract cost centre data from the description field below. In a new column, I want Alteryx to extract the cost centre. It always begins with cc then followed by 4 digits. Sometimes there will be a space in between. I would appreciate some help and ideas on how to do this

Description

1214413891 cc2621 NC687062
1214413891  cc2621 nc687062
1218547203052023 02062023 E cc 2138 nc 697015 
1218564403052023 02062023 E nc 687015 cc 2980
1405818163 cc2090 nc687062
1443838709 nc687062 cc2782

[ShankerV · Accepted solution]

Hi @Mamamia 

Please make use of the below Regular Expression in Regex tool.

(cc\s{0,1}\d{4})

Output method: Parse

Many thanks

Shanker V

[binuacs]

@Mamamia One way of doing this

[Mamamia]

Thank you