Solution to a problem presented in a real interview, using ReFramework, PDF file, text files and MS Excel.
The technology used in this project is UiPath 2020.10.2
The following needs to be applied and show in your coding.
- RE – Framework
- Using a Queue
- Best practices and standards
- Effiency
- Creating the queue
a. Read the contents of the extracted zip folder (RPA – UiPath – Test\1_Question)
b. Add all the .txt files to the queue by adding the filename to the transaction specific content. - Processing the queue
a. Read the transaction item and retrieve the filename
b. Filenames that contain a digit, rename the file by removing the digits.
c. Filenames that has no digit, rename the file by appending the index of the transaction number followed by a “_” separator. e.g. 1_Filename.txt
i. Transaction number should start at 1.
d. Move the file (.txt file) to a new folder Output/Files Moved/
e. Read the file WordIndexes.xlsx
f. Retrieve the Word Index based on the filename
g. Read the Trump Ipsum - Make placeholder text great again.pdf file and retrieve the word based on the index from step 2.f.
h. Write the word to a .txt file called Answer - Format the Answer.txt file so that all the words are in 1 paragraph.