Extract pdf from email,scrape the data,match with excel mapping sheet and move

Hi everyone,
I require the solution to my problem as soon as possible.I have some pdfs in mail.I have read them from the mail and put them in one folder.Then I scrapped the required data using Matches and used for each to iterate through each pdf.I have an excel mapping sheet where I have a column which should be the folder name for an output variable if its value matches with any of the column in the sheet.How to move that pdf into that specified folder?

@Kartika Welcome to uipath community there is a activity called Move File you can use this

Refer this document

1 Like

Hi @indra
Thank you for your reply and it worked out.I am struggling with String Manipulations as I have a big and scattered text file and I just want to extract a small piece of data from it.I am not able to understand how to achieve that.Could you pls help?

1 Like

@Kartika Can you share the text input and expected output of the text file

1 Like

Sure,I am sharing the input text file and i just want the output as
Drawing Title:Basement Plan
Drawing number: P306479-A-FP-201P306479_A_FP_201A - BASEMENT PLAN.pdf (426.1 KB)
I hope you could help me,I am in crisis,
Thankyou for the reply BTw

Are you not able to achieve this with regex?

1 Like

Sorry,I by mistake shared the pdf and now I am sharing the text filePDFOutput.zip (3.6 KB)

I have no concept clarity on Regex,so I dont know how to properly implement it

Its quite simple. So you just want Drawing Title:Basement Plan
Drawing number: P306479-A-FP-201 from the text file?

1 Like

yes,I want then to store it in a variable and move it to excel

The drawing number is not present in the text file that you provided

1 Like

It is there, not in the same line ,I wrote it full in one of the above replies

is it this “E Drawing No.:”?

1 Like

yes,

This is the value of that?
“E Drawing No.: Rev.”

1 Like

No,This is what I was getting using Matches but this is not the value.The value is P306479_ A- FP- 201.This is in the next line from Drawing Number.

yeah. Let me see

1 Like

Sure,I am waiting and thanks for helping me out.

1 Like

Is there anything constant here which will not change?
P306479_ A- FP- 201

1 Like

This value is fixed.It wont change.I just want to extract it as it is and then put it into an excel sheet