Hi guys,
I'm currently doing some work a messy dataset and one job I've been asked to do is extract the 2/3 or 4 letter code from the data into a new column.
Regex was never my strongest point but I have it a go nonetheless to no avail. The Sample data I have had as structure like so:
ABC Testing for bugs
ZZ Test Home
ABC: Test scripts
CONS - Testing Rundown
The data will always be like this apart from these 4 variances there are no others
I appreciate this probably is a very easy or maybe undo-able task but I appreciate any help provided your saving me from insanity 😂
