Extract length information from text

[SIMMI]

Hi,

I have a column that basically stores large sentences as feedback. I wanted to extract the length information from the long text into a new column ('Length Extract'). The actual column is 'Comments' that contain length info.

I have created a column that takes words that end with 'm'.

Unfortunately I couldn't provide a list of values in the 'Text.StartsWith' function. Since I couldn't filter the text that starts with only numbers, I'm getting all words that end with m. I wanted to extract only words that start with numbers. 

Could somebody please help me to further filter this out?

Thanks in advance.

[shrabedi]

Hi @SIMMI 
If data model size is not your problem.
You can use COLUMN FROM EXAMPLE and extract 1.5m and 100mm separately and combine columns afterward to get your result.

I have attached a picture for reference.

Mark as a solution if it's helpful
Regards

[lbendlin]

... and not List.Contains({"0".."9"},Text.Start(_,1))