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.
The paths isn’t from the data table, the dataTable only has the file name from the excel, then I’m using PathFiles + DTDeceased.rows(counter)(0).ToString and trying to merge with “.*”
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)
@cteixeira - so you have the file name listed on the excel file and you are reading the files right?? while reading you just want the extension of that file which you reading??
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”
Run this workflow as is, you will see the files get moved to the “Moved” folder where jpeg file with unmatched searched left in the “SearchFolder” itself.