Hello, I need help splitting a column that does not have a delimiter.
Please see the example below.
@pierrejames I assume your cretia for the 2nd row is to take the five digit after the two letters.
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
