Hi All
I need to check whether the given address is valid only if contains the strings like "Ave", "St", "Blvd" ,"Rd" . I tried using the match Regex() function with the following syntax, However its not yielding the desired results. Following is part of my "Address filed"::-
The Regex used in Information Steward :-
BEGIN
RETURN match_regex($Address, '"Ave","St","Rd","Blvd","Dr"', 'CASE_INSENSITIVE');
END
The test results (unexpected):-