How to open folder and extracts data from the file and paste it in excel

Hi @Tabbu

It will work as bot will look only for the textfile having Region name. so filecollection(0) will always return your region file even if it is any subfolder.

Please share your xaml if possible or check your code by debugging it.

Thanks,
Boopathi

Thank you for your effort.Now the error is solved but i m not getting any value in “Code” column.
Pls help little more!!

Hi @Tabbu

Please debug and check str_Code value is empty in that regex…it must be captured then only it will update or please share your xaml if possible.

Thanks,
Boopathi

Yeah it is empty. Is it becoz of there are some spaces after the CODE text?

Sorry i cant share it.It is confidential

hi @Tabbu

Please attach some test.txt like how your region text file is with some test information.

Bot will extract the code value even if code value in text is like “CODE 8989743”. if it is not in this format then regex needs to be changed accordingly

content://com.android.chrome.FileProvider/images/screenshot/16366309180741276750420.jpg

This is how the formate is of txt file
Below code there are also many lines but i want that particular no. Only

hi @Tabbu

image is not visible.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.