Forum Discussion

SIMMI's avatar
SIMMI
Frequent Visitor
3 years ago

Extract length information from text

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.

 

2 Replies

  • shrabedi's avatar
    shrabedi
    Frequent Visitor

    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