Portal filter script
I have a portal to another table in my file. I want it to filter the results by a partial search match.
If the "room number" of the entry appears within the "adjoining rooms" field of the related table I want the entries to be displayed in the portal.
The script I currently have set is:
PatternCount ( Door Schedule::Adjoining Rooms ; Room Data Sheets::ROOM NO ) > 0
This is working when the adjoining rooms has the room no within it exactly with no spaces and with each entry on a new line
I want to ensure it works if it's entered with a space rather than a return