How to find the name of a file in a folder

[Trevor Hughes]

Hello

I am currently using the following to get a list of files in a folder to use in my script:

GetFileList>c:\Temp\*.*,files
Separate>files,;,file_names
ArraySort>file_names

This works well in giving me the full path to the file. However I want to use a variable to store just the filename (without the path),

Could anyone help with this.

Kind regards
Trevor

[Grovkillen]

Use the extract filename command

https://www.mjtnet.com/manual/index.htm ... lename.htm

[Neib74656]

Hello Everyone,

This seems to work for what I need but only on a single file.

I need to extract the file names to rows in Excel. Is it possible to do this without looping extract file name?

[Dorian (MJT support)]

I hope I'm understanding correctly, but if you're using GetFileList and then looping through the results extracting the file names, ExtractFileName would need to be inside the loop :

Code: Select all

Let>GFL_SORTTYPE=3
GetFileList>d:\compiled\*.*,files
Separate>files,;,file_names
 
Let>k=0
Repeat>k
  Let>k=k+1
  ExtractFileName>file_names_%k%,ThisFN
  mdl>ThisFN
Until>k,file_names_count

Then of course the code that writes to Excel would also be in that loop.

[Neib74656]

Thanks Dorian!

I was hoping to avoid doing it with a loop but I guess it is the only option.

Thank you as always!