I have a field in a SQL table that lists the filenames of documents, but if there are multiple pages in the doc then it runs the filenames together like this:
I'm trying to figure out a way to take documents where the pages are greater than one and split the FILELIST value into the separate filenames. They're all 8 characters long so I'm sure there's a simple regex or something I can do, but I've never been very good at it. I can use \d{8} to capture the first set of eight, but I don't know how to capture every set and split them up.
I've also got scenarios like this where sometimes it has the filepath; I tested out using the same "\d{8}" and it matches the eight digit names I need, but again I don't know how to assign the different sets to the token