Solved

How to find alphanumeric strings and replace them with a null value

  • 23 December 2021
  • 2 replies
  • 20 views

Badge +1

I have a column in a table with names and I want to find the ones with alphanumeric string and replace it with a null value. Apparently this is erroneous data in the table.

 

Sample Data in the column NAME:

GREEN-BROWN TREES --> Leave as is

FORT/STRONG -> Leave as is

PEACE RIVER --> Leave as is

3T7H8HF54FD --> This is the data I want to find and replace with Null

 

Greatly appreciated.

 

Thank you.

 

 

icon

Best answer by redgeographics 24 December 2021, 09:28

View original

2 replies

Userlevel 4
Badge +25

You can do that in an AttributeManager using a Conditional Value on that attribute.

Screenshot 2021-12-24 at 09.26.58So if the attribute contains the regex \\d (any digit) it'll map to a null value, otherwise there's no action and the original value is retained.

Badge +1

You can do that in an AttributeManager using a Conditional Value on that attribute.

Screenshot 2021-12-24 at 09.26.58So if the attribute contains the regex \\d (any digit) it'll map to a null value, otherwise there's no action and the original value is retained.

Thank you @Hans van der Maarel​ 

Reply