Skip to Content
0
Jun 16, 2016 at 05:21 AM

Syntax for matching the string patterns in Match Regex() in information Steward?

2465 Views

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):-

Attachments

Address field.png (11.5 kB)
TestResults.png (5.7 kB)