This is probably straightforward, but I'm struggling with it...
I have a module that includes historical department names, which are combinations of numbers and text, i.e. "5100 Engineering". Sometimes the department names change, for example "5100 Engineering" might become "5100 Core Engineering".
I want to create a list formatted line item in the module that looks up the current department name based on the 4-digit number that proceeds the name.
The "active" department list contains a property that isolates the 4 digit string ("5100"), and the module contains a line item with the same string ("5100"). Both the list property and module line item are currently formatted as text.
Any tips of how to use those two values to find the list item?