Regular Expression with Workato Lookup Table

[hendrykurnia]

Hi guys,

I have a use case where I use regular expression to validate the input of postal code.

E.g. Formula = "95000-2707".match?(/(^\d{5}$)|(^\d{5}-\d{4}$)/) for matching the US postal codes.

However, this method won't work if the regular expression is stored in a lookup able.

E.g. "regular_expression" lookup table

country	regex
United States	/(^\d{5}$)|(^\d{5}-\d{4}$)/

Formula = "95000-2707".match?(lookup("regular_expression", "country": "United States")["regex"])

I have also tried the following formula but no luck.

- "95000-2707".match?(lookup("regular_expression", "country": "United States")["regex"].to_s)

- "95000-2707".match?(/lookup("regular_expression", "country": "United States")["regex"]/) and "95000-2707".match?(/lookup("regular_expression", "country": "United States")["regex"].to_s/) with the following lookup table

country	regex
United States	(^\d{5}$)|(^\d{5}-\d{4}$)

Thank you

[gary1]

Well, that's a whole lot easier! You know, when I was working on the script, I also had to remove the '/' at the beginning and end to get it to work, but I didn't think to double back and check if that would work with Ruby! Glad it's all working now.