Return only numbers and filter out text from column contents

3

hi @Ben_Peine
what about :

thisRow.columName.Split('').Filter(currentvalue.isNumber()).Join('')

Turn the string into a list of items via Split(), evaluate each item in the list (number or not) using Filter and isNumber() and glue it together via Join()
this will return the string with only the numbers
cheers, Christiaan

2 Likes