Split a column at the beginning and end without using a delimiter.

[pierrejames]

Hello, I need help splitting a column that does not have a delimiter.

Please see the example below.

Input data:

Account

BA1234567

Output data:

Account

12345

[Qiu · Accepted solution]

@pierrejames 
I assume your cretia for the 2nd row is to take the five digit after the two letters.

[fmvizcaino]

Hi @pierrejames ,

Here is an example for you.

First I'm using regex to identify strings with no numbers and then using right + left function to remove the first and last 2 characters.

Best,

Fernando Vizcaino