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?
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?
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?
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?
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
It is there, not in the same line ,I wrote it full in one of the above replies
is it this “E Drawing No.:”?
yes,
This is the value of that?
“E Drawing No.: Rev.”
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
Sure,I am waiting and thanks for helping me out.
Is there anything constant here which will not change?
P306479_ A- FP- 201
This value is fixed.It wont change.I just want to extract it as it is and then put it into an excel sheet