How can I regex look up a PDF file from a Multiple File Field based on name field?

Vercimak_176739 Posts: 5
edited May 2023 in Questions

I have a web form with a multiple file field for PDF attachments.

I'm trying to match name ex. Mary Smith to the matching PDF ex. Mary Smith PDF or Mary_Smith_PDF in the multiple file field to then add the matched PDF to another table. Right now I'm using Tables: Look up data in column, it's trying to look for {{associate-full-name}} PDF.pdf in the Filename column of the PDF Submission multiple file field and extract the ID column to output PDF.

I'm having a hard time getting the look up to work but ideally I'd like it to be slightly flexible on the name formatting but I can't figure out how to do it even when they're exactly the same.