Remove Numbers from Text String if Numbers 4 or more digits long

[daniel885]

Hello all -

I have data in a text string field that includes user inputted notes but I want to remove any numbers over 4 digits long from the list.

I wrote this and it works but removes all numeric characters. Is there a way to condition the below to remove only the numbers when 4 or more consecutive digits long? Thank you!

Text.Remove([#"Notes"],{"0".."9"})

[amitchandak · Accepted solution]

@daniel885 , Have you tried

Text.Remove([#"Notes"],{"4".."9"})