Updating a coulmn

razzy

Hi All,

I have a column that do contains , alpahanumeric values and wholly numeric value: 

e. g  m2345t>0

         234578

         TTTYUG65H

        5657890

what i need to do in this coulmn is to remove all numeric values and just stay with the alphanumeric

This transcend to :

     m2345t>0

     TTTYUG65H

      FULLAH

 no whole numeric field 

Can someone help with this please

CharlieS

I suggest using a RegEx function in a filter tool. Here's the formula for the filter tool:

!REGEX_Match([Field1],"\d+")

An example solution is attached to show this in action.

20181019-RegExFilter.yxmd