Alteryx Designer Desktop Discussions

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

Reg ex parse - URGENT PLEASE!

chiragpatel_1
8 - Asteroid

I have a postcode column which goes like this:

AB21

G51

G5

CW9

 

 I want to parse a new column in which there should be only be letters letters of that postcode, I have one below but it's only returning single letter and nulls,

 

please help

 

chiragpatel_1_0-1639736683106.png

 

Thank you 

1 REPLY 1
Martyn
9 - Comet

Try a formula with REGEX_Replace([kpostcode],"\d","")

 

This will strip out all numerics from your string

Labels