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
Solved! Go to 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
@Mamamia One way of doing this
Thank you