IPA to find files in subfolders

Hi Srini Rao - the FileAccess node as a "List Files" option. I think that's what you're looking for.

Sorry, I'm wrong. Actually, this will list the files within the designated folder but it will not show subfolders or files within subfolders. Instead, I think you'd need to use the System Command node to get all files and folders.

Thanks, I tried ListFiles but did not work, let me use the system command to get the list.

Thanks

I was able to do it with System Command using command "dir {path} /s /b /a-d" This lists files recursively, excludes headers/footers, and excludes directory entries. I then followed that with a DataIterator node to separate the returned data into individual records.

I used the /s /b and it worked thanks

Another question, I have text file, How do I read the text file in my program.

 

 

It depends what you need to do with the file's contents.

If you want all the contents at once, you would use the FileAccess node in "read" mode. You pass in the path/filename (must be a path that the server can see directly - i.e. not a UNC path) and it will return the contents of the file into the node_output variable.

If you need to parse the file (I.e. process a csv file) you would use the DataIterator node with input method "file" (same file location limitation as above) to parse the data by line, then pass the output from that node into another DataIterator node with input method "data" to parse it by delimiter or column.

Thanks Woozy , I was able to use "read from file" and it returns me all records. But how do I process a record at a time. Sorry Again....

I need to process the individual records. :-)

Thanks Again.

Read the second paragraph of my previous response. That answers your question.

I missed it Thanks Again.

let me try.