Hi -
I have a dataset with the following column
ABCD1234
ABCDE1345
ABCDEX2345
The alpabets can vary, but the numeric length is always 4 character
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