RE Framework Tutorial 6.0: Data Extraction Process using Regex

In this tutorial, RE Framework is designed for working with file system.
Here,
1) There are some text files provided in a folder.
2) From each text files, email, mobile no, username had to be extracted by using Regex
3) After extracting these data from each text files, an email has to be send in tabular format comprising email, username, mobile no with subject as username
Challenge Link: • RPA Real Time Project ...
Solution Link: github.com/niv...
To know more about regex , refer the following link:
www.rexegg.com...
Doing this challenge will gain good concepts in:
1) RE Framework involving files
2) Regex data extraction
3) Writing Email body in HTML
If you like this video, please subscribe for more updates 😊😊😊😊😊
Happy Automation
#uipath #rpa #reframework #nivedautomation

[@yashobantadash6670]

great job Nived! awesome series of reframewok . keep it up 😊😊👏👏

[@sharvareenabar8261]

Watched the complete playlist of RE Framework. Nice explanation. It made all my concepts clear. Thank you. :-)

[@nivedn5194]

Glad to know it helped you a lot
Let me know if you need any topics related to reframework around
Regards
Nived N

[@adityaahirrao4851]

Good Work !!

[@nivedn5194]

Thanks bro

[@gattuakhil2319]

very helpful and your explanation is superb

[@sampadakarmalkar2541]

Excellent, it's helpful indeed.

[@amaryelane2615]

Thank You Nived

[@nivedn5194]

👍👍👍

[@vipulpotdar3053]

Hey Nived,
Can you help me solve this task
I am confused about which part of the workflow I should write the code
Using the RE framework create a new template from the studio
Change the transaction item type from QueueItem to DataRow
The exercise consists of reading the pdf files stored in Input Folder and extracting the information
- Invoice Number
-Order Number
-Invoice date
-Due Date
- Total amount
Once all the information has been read, sort the information by "Due Date" from newer to older date in an excel file

[@KunalKumar-tt4bt]

sir if we have some pdfs what to do

[@nivedn5194]

Are u asking like if we had pdf files along with text files in this process how would u deal with that ?

[@KunalKumar-tt4bt]

what to do in initialization

[@nivedn5194]

Hi
Do u refer what we need to in intialization in this process or in general one ?

[@KunalKumar-tt4bt]

@@nivedn5194 sir I want to extract data from pdf multiple pdf with re framework can u plz make that type of video

[@nivedn5194]

Let me see Kunal thanks for your suggestions ☺️
For extracting data from pdf, the same approach as u see in this video has to used but instead of reading text files , you had to use read pdf activity to read the pdf and extract the required via regex or string manipulation

[@shreyaagalduty861]

Hi,
I need to extract data from pdf file and write that to excel using regex.
Can u help me on this

[@nivedn5194]

Hi Shreya
Sure

[@KunalKumar-tt4bt]

sir i want to extract data from 5 pdfs using regex i have to ceate dynamic regex or normal regex will work for every file

[@nivedn5194]

If you want to extract same data from all pdf then u had to use a regex pattern which can extract the same data from all

[@MemoriesToRemember]

Thanks for the Video!!!

[@KunalKumar-tt4bt]

How to store folder pdfs in transaction item

[@nivedn5194]

I am not getting ur question
Could u explain it better?

[@KunalKumar-tt4bt]

plz explain about transaction item

[@nivedn5194]

In Reframework, the approach is transaction processing
So transaction item concept is used in Reframework
U can think of transaction item simmilar to excel rows.
Assume you had excel data which had 10 rows , now u need to process 10 rows each. So here in this case, each row will act a transaction item

[@rakeshtiwari6777]

Hi Nived, can i have the email text file?

[@nivednambiar6845]

Hi Rakesh
I had attached the solution workflow in the video description
You can find that there

[@rakeshtiwari6777]

@@nivednambiar6845 ok thanks

[@adityaahirrao4851]

can i just get your mail id ?

[@nivedn5194]

Ya sure
[e-mail]