I am trying to write a rule where I need to find where the first word of one field matches the last word of another field.
Here is an example of the data:
System 1 Address Line 1: 316 E 1ST ST
System 2 Address Line 1: E 1 ST 316
To get the first word, I am using this logic.
I am not sure what logic would be used to get the last word.