Forum Discussion
SIMMI
3 years agoFrequent Visitor
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
- lbendlinSuper User
... and not List.Contains({"0".."9"},Text.Start(_,1))