How do I pull out an alpha prefix from an alpha-numeric chr field?

User: "Altair Forum User"
Altair Employee
Updated by Altair Forum User

I have a character field (client account number) that is made up of an alphabetic prefix followed by numbers. Since I need to leave the client account number intact, I trying to find how to create a calculated field that pulls in only the alpha prefix. The length of the alpha prefix varies from 2 to 5 characters.

 

Below are a few examples:

DOT032440

PC14888

RHEA789442

LAWNV7894457

 

I would appreciate any help available. Thanks,

Diane

Find more posts tagged with