Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Pulling 2/3 or 4 letter code from different locations

Deano478
12 - Quasar

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 😂

 

1 REPLY 1
Hammad_Rashid
11 - Bolide

Regex : \b([A-Z]{2,4})\b

 

Capture.PNG

 

 

Labels