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.
You can do that in an AttributeManager using a Conditional Value on that attribute.
So 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.
You can do that in an AttributeManager using a Conditional Value on that attribute.
So 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