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 i...
Thanks Gary.I would like to share what I have found. Actually, removing the '/' at the beginning and end of the regex in formula syntax and lookup table works.countryregexUnited States(^\d{5}$)|(^\d{5}-\d{4}$)"95000-2707".match?(lookup("regular_expre...
Thank you Gary.I tried this out and worked. Quick question, I'm trying to map and update batch of 100+ records in this use case. With this method, is there a way I can map the batch record? Or do I need to loop each record to with the Javascript act...
