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

Help
, , ,
1

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?

2

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

Refer this document

1 Like
3

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
4

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

1 Like
5

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

6

Are you not able to achieve this with regex?

1 Like
7

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

8

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

9

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

1 Like
10

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

11

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

1 Like
12

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

13

is it this “E Drawing No.:”?

1 Like
14

yes,

15

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

1 Like
16

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.

17

yeah. Let me see

1 Like
18

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

1 Like
19

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

1 Like
20

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