Using SysCommand instead of .bat file

FireGeek21

Veteran Member

Posts: 84

6/6/2017 2:03 AM

I have the following in a .bat file but we are moving to the cloud and cannot use .bat files. How can I do the same thing using a syscommand node? Or is there a different node/combination of nodes I should use to count the number of a certain type of files in a folder?

@echo off
setlocal enableextensions
set count=0
for %%x in (\\servername\appprodline\foldername\*.RQ500) do @(set /a count+=1 > nul)
echo %count%
endlocal

Thanks!

David Williams

Veteran Member

Posts: 1127

6/6/2017 7:22 AM

You can use the File Access to list files that match your syntax. The output will be a comma separated listing, which you can treat as an array. Then simply get a count of the elements in that array.

FireGeek21

Veteran Member

Posts: 84

6/6/2017 12:59 PM

Thank you David! I really appreciate all that you have to offer here!