Hello Everyone,
I am struggling with a problem that I couldn't find any solution on other topics that can fit my request.
I have a database from which I need to extract the first 4 to 9 digits on a separate col. in order to use it for a Join, but there is no specific conditions that are applied. On the photo attached you can see the input and the output that I want to have. I tried to eliminate the letters with the Data Cleansing tool, but after I need to find out how to extract the first 4 to 9 digits after first: space or / or . or , or any other characters.
Thank you in advance!
