+6I 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.
Best answer by redgeographics
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.
+49You 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.
+6You 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
