Hi there,
I am using a RegEx Check to check phone number formats. I am using a Reference table lookup with a single column that has the Regular Expressions, the full table also indicates which Region (UK etc) that phone number corresponds to. Once I have a RegEx match, I would like to check and see if the region corresponds with the inbound message (i.e. UK number, UK customer).
Does anyone have any suggestions as to how I could achieve this? I would like to keep a single reference table for all RegExs as it makes it easy for the business to add to/edit.
If there were some way to indicate which row in the reference table the match was made, I could do this but I have not been able to find a method yet.
Many thanks