You would be able to do this with the Ruby "send" method, something like this:
[postal_code].send("match", regex)
But alas, Workato doesn't support "send".
However, you can still do this with a JavaScript action.
Set it up like this:
And use this code:
exports.main = async ( {term, inputRegex}) => {
var reg = new RegExp(inputRegex);
result = reg.test(term);
console.log(reg);
return { result };
}
Hope this helps!
Glad this worked.
It's possible to do this in batches. Here's the updated code.
The postal_codes input is an array of postal codes and countries. You'll need to match this format from your source data.
The lookup_table input is the entire lookup table (use the "Get all entries from..." action)
And here's the updated code:
exports.main = async ( {postal_codes, lookup_table} ) => {
console.log(postal_codes);
const lut = lookup_table;
const response = [];
postal_codes.forEach(function (i) {
console.log(i);
let pc = i.postal_code;
let c = i.country;
let match = lut.filter(function(l) {
return l.entry.col1 == c;
});
let reg = new RegExp(match[0].entry.col2);
let result = reg.test(pc);
let resultObj = {
postal_code: pc,
country: c,
regex: reg,
result: result
};
response.push(resultObj);
});
console.log(response);
return { response };
}
FYI, there's no error handling in this, so if the lookup fails, the whole thing might crash. JavaScript is not my native tongue 😛
