How to use a field using regex for the condition like:
field A can have only - and () special characters
Hello @simran2003,
Then you can use this:
REGEX_Match([Field1], '[\d\-\(\)]*')
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Regards
Using this formula
REGEX_Replace([Field1], '[^\u_\-_\(_\)_\d]', '')
Will give you back only letters, numbers and the special characters you mentioned. If you want to add spaces too:
REGEX_Replace([Field1], '[^\u_\-_\(_\)_\d_\s]', '')
I want to check if the field1 of type double has only - and () as special characters.This code you provided is n't working for it.@afv2688