Forum Discussion

daniel885's avatar
daniel885
New Member
3 years ago
Solved

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

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"})

1 Reply