Split alphanumeric string using Regex

[Noob_1-800]

Hi - 

I have a dataset with the following column

ABCD1234

ABCDE1345

ABCDEX2345

The alpabets can vary, but the numeric length is always 4 character 

[binu_acs]

@Noob_1-800 One way of doing this

[Yoshiro_Fujimori]

@Noob_1-800 ,

If the numeric length is always 4 characters, you don't need to use RegEx function.

Here are two ways. (As RegEx requires more resources in general, I would recommend another option.)

Using RegEx

NumericData = REGEX_Replace([Data], "[a-zA-Z]+", "")

AlphabeticData = REGEX_Replace([Data], "\d+", "")

Without RegEx

NumericData = Right([Data], 4)

AlphabeticData = Substring([Data],0,Length([Data])-4)

Output