SOLVED
Reg ex parse - URGENT PLEASE!
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
chiragpatel_1
8 - Asteroid
‎12-17-2021
02:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Thank you
Solved! Go to Solution.
Labels:
- Labels:
- Tips and Tricks
- Topic of Interest
1 REPLY 1
Martyn
9 - Comet
‎12-17-2021
03:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try a formula with REGEX_Replace([kpostcode],"\d","")
This will strip out all numerics from your string