This would not be possible with regular expressions as it requires analyzing data from two fields. Regular expressions can only manipulate data based on the value in one cell at at a time. It would be possible through a customization in the IOM API.
Would give us a little more information about the IOM API customization, please? Is this similar to the code we had your team build so we could match on address?
Thank you so much.
Yes, it would be similar to that. We could write logic into your profile that would look at the values in multiple columns and assign the relationship value based on the criteria you give us.