I am looking for help to create a Regex dictionary which applies an area code to phone numbers that don't have one based on the value in their state column. This is for Australian numbers so for example if the constituent's address was in Victoria an 03 would be added to their phone number if there were only 8 digits. Can this be achieved?
RegEx can only work with one incoming field; it doesn't have the capability to adjust one field based on a different one.
You can do this using the API if you have access.