So, I have a For Each Row activity to filter some file names from excel (which I’m storing on a data table).
But then I need to access a path with multiple files and move the files that were found above.
The thing is, I can’t find a way to get the extension on for each row, if I try to do something like "filename & “." it outputs like "invoice_123.” instead of “invoice_123.pdf”.
It isn’t only .pdf’s btw, it can be a lot of file types.
It’s something similar to that, but I don’t want all the files in the directory, only the ones that are named on my excel file which I output to a dataTable (but on the excel I only have the filename, not the extension, and it can be .pdf, .docx, .xlsx, .png etc etc)
No, while reading, I need the filename + the extension, what I’m using to get the file name is "DTDeceased.rows(counter)(0).ToString" but if i try to add & “.*” it outputs it like this: “invoice_123.*” instead of “invoice_123.pdf”