Hi,
Can someone help me to build the regex to filter out non alphabets and non numbers as well special characters?
So here is the rule : According to the rule, it means you can have numbers and/or alphabets. You can't have anything else. Nulls can be ignored here
1234 - Keep
ab123 - keep
abcd - keep
anything which doesn't have these combination should be filtered out using the regex
@gotu
use the formula
REGEX_Match([YourField], "^[a-zA-Z0-9]+$")
mark done if solved.
@gotu
find workflow attached.
In a filter tool, use:
REGEX_Match([fieldname],"\w+")
Unfortunately neither worked for me.
One thing i wanted to add is that we can have data as B12 BT5 or 123 456 so there is space allowed when its numbers, alphabets or alphanumeric.
@gotu
update the formula to this
REGEX_Match([fiedl], "^[a-zA-Z0-9 ]+$")
This works for me.
If white space is also allowed, use REGEX_Match([Field],"[\w ]+")
If you still aren't getting the results you need, it would help to share some sample data.