Get file extension with for each row

Help Studio
, ,
#1

Hi,

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.

Any tips guys?
Thank in advance!

Forum Engagement Daily Reports
#2

Hi;
Where do you have the full information about the file name "invoice_123.pdf”?

#4

@pravin_calvin thank you, but it doesn’t happear to me :confused: image

#5

Hi @Nadia_GHOUFA , on a variable named “Path” that’s where all the files are

#6

@cteixeira -Its path.getextension(yourpath)

#7

Hi @cteixeira

Can you send me a screen shot of path which you are getting from the datatable?

Thanks

#8

It doesn’t recognize it :confused: image

#9

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 “.*”

#10

@cteixeira - is this what you are trying to fetch??

image
image1064×384 16.6 KB

#11

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)

#12

@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??

path.getextension(row(“Filename”)).tostring…

#13

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"

#14

@cteixeira - Please post your input file screenshot and workflow where you got stuck?

#15

Here the workflow: !workflowimage|288x500
What it looks on excel: !excelimage|177x62

#16

@cteixeira - Really sorry…still i am not able to get exactly what you are trying to do? and the screenshots are not informative too…

#17

I believe it should work with:

arrFiles = Directory.GetFiles("C:\YourPath", DTDeceased.rows(counter)(0).ToString + ".*")

It returns an array of string with all the matching files.

Example:

image

image

1 Like
#18

I will try that thank you!
Can you please just let me know how can I output the array?

#19

So…

  1. I have a DataTable with file names without extensions “invoice_123” (it can be any extension)
  2. I have a folder with a lot of files including the ones that are on the Datatable
  3. I need to move those files mentioned in the DataTable to another folder
#20

A For Each loop is recommended since you don’t know how many matches you will get:

image

#21

@cteixeira - Please find the starter help here…Seach_And_MoveFiles.zip (48.5 KB)

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.