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 · Accepted solution]

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.

[Claje]

Another way to approach this which can handle things like decimals in numeric fields is to use the following formula:

ISNULL(TONUMBER([Field1],1,1))

This will convert your field to a number in the filter, replacing all non-numeric fields with a null value.  By filtering to only show values that would be null when converted to a number, you get all non-numeric fields.