UiPath | How to loop through and open files in a folder | Tutorial

[@ramachandrarajuav]

Thank you Jensen. Very understandable. Informative.

[@andersjensenorg]

Thanks for the kind words, Alluri 😊 Kind regards, Anders

[@MrAnupam200]

Hi Anders, Another great video. I used to eagerly wait for your videos. Regarding this video I have one query whether this works for eml files... I have set of eml files and I have to change it to pdf by opening eml files and click on file than save as pdf...So this steps can be performed??

[@andersjensenorg]

For sure. We just need to specify, which application that will open the eml files 🙂 Kind regards, Anders

[@andersjensenorg]

And thanks a lot 🤩

[@tabassummansuri7998]

Thank you for the nice explanation. After this process how do i fetch a particular word(eg code 1467 is given in notepad) from txt file nd paste it in an excel file

[@andersjensenorg]

Hey Tabassum Mansuri Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@jam05eun]

very helpful video :)

[@andersjensenorg]

Hey jam05eun. Thank you 😊

[@bfan2151]

Good video! Do you know how to open multiple Excel files in a way like this: 1) open Excel application when you open the first Excel in the file list, 2) save as into another folder, close the file but keep the Excel application live (so you can save time) 3) open the next Excel file...

[@andersjensenorg]

Hey B Fan Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@ra77le]

Hi Anders, do you know if it is possible to use "Find children" activity for items in winform (desktop window) box and iterate through the list :) ?

[@andersjensenorg]

Hey Lukasz. No, have you tried? What is Winform btw? 😊 Kind regards, Anders

[@murugand4158]

can you make video for Copy Data Paste Another Workbook Transpose automatically using Uipath ??

[@andersjensenorg]

Hey Murugan. At the moment I don't have time, but feel free to place your question at my Discord, and the guys will give you an answer: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@cheeku0]

Hello Anders Could you please advise on this question: How do I trim/remove last 7 characters from a filename? I need to save the file names by removing everything after an underscore. ex: ABcdEFg_mp.DST , I need to save the file as only AbcdEFg and this is for multiple files. Please help

[@andersjensenorg]

Hey Raja. The best way to do it is to use some VB. "ABcdEFg_mp.DST".Substring(0,"ABcdEFg_mp.DST".Length-7) This will extract your string from position 0 (the first) to position length -7. Let me know, if that helps? Kind regard, Anders

[@cheeku0]

@@andersjensenorg Hi Anders thank you very much for the help. I will let you know once I work on it

[@cheeku0]

Hi Anders, I am able to trim the file name now. But how do I do this for multiple files in a folder? Can that be achieved? Thank you very much for all the help so far

[@redwan1074]

Any idea how I can loop through all files under SharePoint library without syncing the library on local machine? I did try the way you did it, it did not work for SharePoint. Thank you in advance

[@andersjensenorg]

Hey redwan. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@aprendiendorpauipath2759]

276/5000 Hello friend, first of all thank you for your videos, for this process I have a question, when I use the activity get element it selects the entire page of the pdf and I cannot select only the data that I need to extract, what problem can that generate? thanks.

[@andersjensenorg]

Hey AprendiendoRPA Uipath Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@rohantammewar6337]

can you make videos on config files and SAP related question

[@andersjensenorg]

Hey Rohan Tammewar Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@jrjr5861]

hi Jensen, why i dont see start process in my activities in UI Path Studio?

[@andersjensenorg]

Hey ong JR. It is the drop down in the Debug button. Can you find it? Kind regards, Anders

[@jrjr5861]

@@andersjensenorg hi anders thks for reply, after I restarted it seems to appear now not sure why thks!

[@andersjensenorg]

Weird. If you have any questions and/or suggestions for the video, just let me know 🙂 Kind regards, Anders

[@jrjr5861]

@@andersjensenorg Hi Jensen, now that you mentioned actually i do! it is however quite complex not sure if you would cover in 1 video - How do you execute a macro (from a personal workbook) for multiple new files in a folder? ie its a folder where 2-3 files are saved daily thus the need for UIpath to lookup "new" files. BTW - thks for your videos, its really helpful!

[@raysha2123]

Hi, If in the first run the bot reads two files out of 4. Now for the second run I want to read the files which wasn't processed i.e. the last 2 files. Any idea on how to do that?

[@andersjensenorg]

Sure. How would a human do? Look at the dates?

[@raysha2123]

@@andersjensenorg check If the filename is already processed and based on that??

[@sujithnaik2916]

Scenario : I have three files in the folder, with different names ofcourse . I want tio iterate through files the folder and move each file to different location based on their names. example, A.xlsx file needs to be moved to x folder , B.xlsx needs to be moved to Y folder, C.xlsx to be moved to Z folder. How do i do that ?

[@andersjensenorg]

Hey Sujith Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@harinilv8591]

Hi, did you got any solution for this?