Parse all records after n characters

Hi,

I have a list of codes that contain three letters followed by several numbers (numbers can vary). Here is a sample:

VWN29747

BSA1927330

GST38559

MBU113445

I want to remove all letters and just keep the three letters in the front. I have attempted to use the Text to Columns tool and the Formula tool with something like this:

Left([Dealer Code], Length([Dealer Code]) -3)

I also tried to wrap my head around RegEx, but I am not quite getting it yet. Any suggestions are greatly appreciated!

Regex

Preparation

Accepted answers

unknown

Formula tool, select the Dealer Code field and enter the formula: LEFT([Dealer Code],3)

ddiesel

Just to chime in with an alternate solution... I use the Cleanse tool a lot.

There is a "Remove Unwanted Characters" section that includes options for removing Letters, Numbers, Punctuation etc.

All comments

unknown

Formula tool, select the Dealer Code field and enter the formula: LEFT([Dealer Code],3)

MarqueeCrew

Letters:

Left([code],3)

Numbers:

substring([code],3)

cheers,

Mark

kheuer

I knew it had to be something that simple. Thank you so much!

ddiesel

Just to chime in with an alternate solution... I use the Cleanse tool a lot.

There is a "Remove Unwanted Characters" section that includes options for removing Letters, Numbers, Punctuation etc.

kheuer

I like this approach as well. Thank you!!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703