How extract digits from text, without using R and python scripts.

[leopoldvili_1]

Hi, I would like to extrat digits from the text, unfortunatly I cant use R script and regex as refreshing is not working on Server.

Here is example: it is always 5 digits, I would like output as it is in regex column. Also when texts includes "OD"-12900 it should not be extracted and it should be ignored and  as it is in regex column , or when digits is more/less then 5.

Can any one give me some tips?

Thank you in advance.

[amitchandak]

@leopoldvili_1 , There is something known as split by digits and non digits in Split column in Transform Tab of power query, You can also use Text.Contains before that.

Split Column By Digit to Non Digit & Non Digit to Digit: https://youtu.be/tY4Yk1crS9s

[leopoldvili_1]

Hi, I tried  split by digits and non digits in Split column but it is not helping as my digits should be 5 and some text with digits should be exluded completly like OD-12900.